certificate's questions - English 1answer

42 certificate questions.

SQL Server 2008r2 I'm trying to drop a certificate I've created but i get the following error The certificate cannot be dropped because one or more entities are either signed or encrypted using ...

I suddenly start to get the message while performing backup, I know i have taken backup of the certificate and stored it in my password manager which I still have access to. My question is that do we ...

I have a certificate I would like to remove from the database. If I issue the command DROP CERTIFICATE <FooCert> I get the error The certificate cannot be dropped because one or more ...

I am trying to load some sample JSON data into a MongoDB database (hosted on IBM Bluemix). The connection requires SSL, and a SSL Certificate has been provided, but I keep getting an error when I ...

I have a hostname and a port. How do I inspect the public X.509 certificate used to protect the endpoint. It is possible to talk to the SQL server both encrypted and non-encrypted; however I have ...

Using SQL Server 2017 Developer Edition The command I'm using is: New-SelfSignedCertificate -CertStoreLocation Cert:\LocalMachine\My -DnsName host.doman.com -KeySpec KeyExchange -FriendlyName ...

I know the rethinkdb guide uses a self signed cert as an example. If I wanted to use a real certificate that I purchased, how can I add the bundle to the server conf? I add the certificate I purchased ...

I'm using MySQL 5.7 and I want to set up SSL to force the client to use a cert. This cert is a self-signed cert that I generate. I have the cert for both server and client being: - CA - cert - key ...

I'm in the process of re-writing our maintenance plans (backups atm)and as part of that, I'd like to encrypt our backups for security purposes. I have managed to get the process working but have ...

Hoping someone can help- I've been experimenting with Always Encrypted columns and have generated a certificate in the "Microsoft Software Key Storage Provider" - How can I remove the "Always-...

I'm trying to perform a restore of a database from a different server onto my localhost server .That database is encrypted (the bak file ) ,so I have to decrypt it ,that's fine I have all the cert ...

some time ago I installed SQL server 2016 developer edition on a windows 10 home edition environment (a laptop to be precise) and everything was fine. then someone - an administrator on the box - ...

I currently configure a MongoDB cluster to use TLS certificate. It could be far more easier to deploy, one certificate with aliases accross all cluster, instead of one certificate per node. But there ...

I am enabling TLS/SSL encryption on a remote MongoDB instance (running on Windows Server 2012 R2). On the instance's server, devserver.external, I have created an SSL certificate. The CN on the ...

I have a situation that, while I was able to work around it (as the repro will show), I don't understand. Here are the high points Two databases, ChainingSource and ChainDestination, both of which ...

Additional Information With SQL Server 2016 SP1 we have the availability to use Always Encrypted functionality with the Standard Edition of the server. One is able to create a certificate in the ...

I'm trying to use a certificate to sign a user-defined function in SQL server (2016). My code is as follows: CREATE FUNCTION myfunction() RETURNS TABLE AS RETURN SELECT col1, col2 FROM ...

in a database that is part of an availability group (alwayson), in the current primary server I create a certificate and sign some stored procedures using it. all is working fine so far. use ...

Question: I am trying to create a single (self signed) certificate and deploy across many databases and instances. I create and backup the cert with: USE MASTER CREATE CERTIFICATE DavesCert ...

I realize this is strange behaviour and I wonder if it is supposed to be working that way when using SQL Server generated self-signed certificate. Client (Management Studio) with "encrypt connection" ...

1) CREATE SYMMETRIC KEY SecureSymmetricKey WITH ALGORITHM = DESX ENCRYPTION BY PASSWORD = N'StrongPassword'; I'm trying to figure out about the SQL Server encryption. once I've executed the ...

Fair warning, I am very new to encryption with DBs. Right now we use the following statement to swap certificates when in the process backing/restoring DBs between servers: ALTER DATABASE ENCRYPTION ...

I want to be able to connect to a database hosted on a Raspberry Pi (mysql-server) from a C# application. In the real world professionals use a Webservice for this, but I want to use the SQL-connector ...

I want to create a new column master key using certificate created in advanced. I use the following command to create a certificate in the Windows Certificate Store - Local Machine. New-...

Is there a way to grant a user permissions to create certificate in SQL Server?

A backup/restore issue has taken place on one of our client’s server. We use Microsoft SQL Server 2014 installed on Microsoft Windows Server 2012. Problem results: - Critical data loss, inability to ...

I use cross database certificates (as explained by Erland Sommarskog) to control access to a certain database in my environment ( SQL Server 2008 R2 ). I have stored procedures in database A that ...

I have created a certificate authority on my Linux server using OpenSSL. I have added that certificate authority to the Windows Trusted Root Certificate Authorities, which it now recognises. What do ...

I am preparing for Microsoft exam 98-364. Which SQL Server version should I practice DDL and DML commands. Microsoft website link specify Technology: Microsoft SQL Server 2008 but I think its old as ...

I'm using SQL Server 2014. From this morning, somehow, an SSL certificate has changed and everything is messed up. I think it was an automatic change and wondering why it occurred? I Started to ...

I plan to migrate a SQL Server database to another server. There is a certificate listed under the Security > Certificates view in SSMS Object Explorer. I ran the below query to check if database is ...

If I have a cert in SQL Server, used for backups: Can backups still be created after cert expires? Can restore still happen after cert expires? What is the point of having these certs expire? (other ...

Assume that there is a certificate created in database create certificate certName with subject = 'subj'; GO And a user mapped to this certificate create user userName from certificate ...

How can I ensure that SQL Server data traffic is encrypted over the wire both from server to client and from client to server? I have set Force Encryption to Yes and that alone seems to hide query ...

After reviewing SQL Server compatibility with New TLS Standards and much Googling, I think we've got the updates and settings needed to disable TLS 1.0 on SQL Server 2008 R2 with .NET 3.5.1. But I'...

I understand the need for backing up keys and user defined certificates, but is there any reason that we should back up these certificates that are system-created? MS_AgentSigningCertificate ...

Based upon the UI dialogue box in SQL Server Configuration Manager, if I right click 'Protocols for server_name', it appears that I can only select one certificate to use. My experience so far tells ...

We have Microsoft Azure with Windows Server 2012 R2 in Cloud Computer and window Server is Standalone it is not come under domain controller. We want to add SSL authentication. SQL Server is not ...

I have a certificate set up to do cross database CRUD operations. The certificate is linked to a user in each destination database. I sign any stored procedures in the source database with the ...

I have created a few Certificates (via CREATE CERTIFICATE) and Asymmetric Keys (via CREATE ASYMMETRIC KEY) and used them to sign and counter-sign various Stored Procedures, User-Defined Functions (...

I am using SSDT 14.0.50730.0 in Visual Studio Professional 2015. I am comparing databases between two instances and it is finding that there are stored procedures that do not match with regard to ...

I have a certificate I am using for inter-DB access to a stored procedure in SQL Server, and am able to provide access to the stored procedure by creating a new user in the database using: CREATE ...

Related tags

Hot questions

Language

Popular Tags