Questions tagged [certificate]
A container for a private and public key pair that includes additional meta-data / properties. Certificates are typically used for encryption as well as generating and validating signatures (e.g. module signing, message verification, etc).
102 questions
0 votes
0 answers
17 views
Setting up Cassandra with PEMBasedSslContextFactory results in configuration error
I followed the guide for setting up client to server encryption with the PEMBasedSslContextFactory for Cassandra at https://cassandra.apache.org/doc/stable/cassandra/managing/operating/security.html#...
- 101
0 votes
1 answer
39 views
SQL Server encrypting backup with a certificate failed with "Cannot find server certificate with thumbprint..."
Here is my demo code: USE master; GO IF NOT EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = '##MS_DatabaseMasterKey##') BEGIN CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'StrongPassword123!';...
- 2,126
1 vote
2 answers
236 views
Self-signed certificate in SQL Server
I can not find detailed information about SQL Server self-signed certificate. I thought that the cert is generated with new date every time restart happens. ChatGPT told me that this certificate is ...
2 votes
2 answers
2k views
Is it possible to register two SSL certificates on SQLServer?
In SQLServer 2019, is there a way to install multiple SSL certificates in parallel? I have the following situation: The division the server belongs to was sold and therefore new DNS aliases were ...
- 123
0 votes
1 answer
447 views
SQL Certificate
Recently, I was asked to apply SSL certs to SQL. After a bit of research, I found an article to add the server cert to SQL using the SQL Server Configuration Manager. When the server cert expires our ...
0 votes
1 answer
102 views
Does the client certificate need to be signed by the server certificate?
I am connecting to a GCP Cloud SQL instance using a client certificate issued by the GCP Cloud SQL service. When I created the client key-pair GCP Cloud SQL gave me three files: a server certificate, ...
- 385
1 vote
1 answer
635 views
Module signing on a trigger which accesses system views. Base table is on a custom schema
Some background: Question is follow up of this question: Is there a way in SQL Server to make a table only able to insert by trigger? I'm trying to achieve what the answer to the original question ...
- 1,560
3 votes
2 answers
2k views
Is self signed cert the standard practice for SQL Server Always Encrypted?
We're implementing SQL Server Always Encrypted in our 2019 environment. We've done several successful POC's over the last few months, but in moving the solution to Prod, I was expecting to use a ...
- 143
2 votes
0 answers
256 views
How to use Custom Certificate for SQL Server Availability Group Endpoint Authentication
I am setting up a SQL Server Availability Group using the commands provided in the Microsoft documentation. The process involves creating a certificate, backing it up with the private key, and ...
- 53
1 vote
1 answer
4k views
No connection possible after TrustServerCertificate=True => The certificate chain was issued by an authority that is not trusted
I have a machine which could connect to an MS SQL Server in the past. I have SSMS installed and the connection was possible when I activated TrustServerCertificate checkbox in SSMS. I could connect ...
0 votes
0 answers
173 views
Cannot send mail through SQL Server sp_send_dbmail. Certificate error
Below is the error message I see in windows event log. No errors while executing sp_send_dbmail Exception Information =================== Exception Type: Microsoft.SqlServer.Management.SqlIMail....
- 5
0 votes
0 answers
2k views
64 bit ODBC connection fails due to certificate not being trusted
I am setting up 32 and 64 bit ODBC connections on 2 identical SQL Servers running SQL 2019 CU18. These are part of the same cluster with AOAG. The primary node gave no problems with 32 or 64 bit ...
- 255
1 vote
1 answer
2k views
Does server SSL certificate update require SQL Service restart
This seems like such a basic question but I'm not finding it anywhere else on the site so apologies in advance if this is a repeat. Some co-workers and I are trying to determine if a restart of the ...
- 11
0 votes
2 answers
122 views
Always Encrypt C++
Our client application is developed in C++ and uses ODBC Driver (Version 17) to connect to remote SQL database. We have enabled Always Encrypt option to encrypt the data. Using proper flags in ...
- 69
3 votes
2 answers
4k views
Renew Certificate in Oracle Enterprise Cloud Control OMS Manager Console
Environment: Oracle Enterprise Manager Cloud Control 13.4 OMS console with third party certificate Secured My situation is the following: I am new in this client and apparently the former DBA added ...
