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).
88
questions
0
votes
1
answer
25
views
MySQL Server Cannot Verify SSL Certificate
I'm trying to configure a mysql server for secure remote connections over TCP/IP using SSL. The server mysql runs on has a domain name associated with it which i have requested a certificate for from ...
2
votes
1
answer
85
views
Cross database access with trustworthy on does not work for service account neither with certificate
I have this setup
I created two databases (source and target).
Source database has stored procedure that is accessing table in target database.
Stored procedure is executed as service account
Service ...
- 951
1
vote
1
answer
82
views
Understanding of database master key in SQL Server
Let's say I have a production server and I have a database master key ##MS_DatabaseMasterKey## (master_key1) on it. I created a certificate c1, which is encrypted by master_key1 by default. Then I ...
- 624
0
votes
0
answers
100
views
Generate MySQL/MariaDB SSL certificates from my wildcard certificate (*.mycompany.com)
I'm configuring a series of MariaDB servers with SSL protection. I was able to do it creating different self-signed certificates, as everybody can do just following some of the multiple tutorials you ...
- 111
3
votes
1
answer
83
views
Is an SSL Certificate Authority Chain "Secret"
We've recently signed up to use MariaDB's SkySQL package, however are new to the use of SSL Certificate Chains when connecting (having only really used SSH tunnels in the past).
We have the key which ...
- 33
2
votes
1
answer
169
views
How do I generate the private key needed to restore the encrypted backup?
I'm simulating the situation where I take a backup from instance A and restore it on instance B. I followed the doc to Backup to Disk with Encryption. Since I'm using only my desktop to simulate the ...
- 4,852
-1
votes
1
answer
466
views
Unable to load user-specified certificate in event log although SSL certificate is installed
Unable to load user-specified certificate [Cert Hash(sha1) "SOMERANDOMHASH"]. The server will not accept a connection. You should verify that the certificate is correctly installed. See &...
- 5
2
votes
1
answer
410
views
SQL Server Profiler - Client unable to establish connection
Spanking brand-new installations of:
Visual Studio 2022 Community (VS)
SQL Server 2019 Dev (SQL)
SQL Server Management Studio v18.10 (SSMS)
There are no other Visual Studio or SQL Server instances ...
- 21
0
votes
1
answer
319
views
Certificate (SHA1) loaded in a database but couldn't be found under SQL Configuration Manager and Key Registry
I have two instances on a server. sql 2014 (port 1433) and sql 2016 (port 50019)
I have a certificate with SHA1 algorithm on a server that is not expired.
**When sql server started I can clearly see ...
- 637
1
vote
1
answer
96
views
If I backup my Certificates, why do I need to backup the DMK?
If I have a server where I use TDE, configured as follows:
USE [master]
CREATE DATABASE MyTDE
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'My57r0ngp455';
CREATE CERTIFICATE MyTDECert WITH SUBJECT = '...
- 1,581
2
votes
1
answer
359
views
Load assembly from a certificate in SQL Server
We received an assembly from external vendor as
CREATE ASSEMBLY MYCALC_DLL
AUTHORIZATION dbo
FROM 0x42A728....<300,000 binary values>
WITH PERMISSION_SET = UNSAFE
GO
And this DLL is been ...
- 342
0
votes
1
answer
192
views
Supported RSA Key Lengths for Encrypted SQL Connections
I'm having trouble finding any documentations regarding supported key lengths for RSA certs to encrypt SQL connections. Our internal CA is issuing certs with a 4096 key length and that seems to work ...
- 223
2
votes
1
answer
1k
views
Azure Data studio - connection to server in the same network - Error: The received certificate has expired
I am trying to connect to SQL server on my network with Azure Data Studio, and I am getting error:
A connection was successfully established with the server, but then an error occurred during the ...
0
votes
1
answer
31
views
SQL Mirroring Replace Certificates
I have inherited two SQL 2016 servers with two mirrored databases.
They have been built with certificates as they are in a workgroup, the certs expire in six months. I am trying to understand the ...
- 425
3
votes
1
answer
679
views
Changing Database Encryption Keys
I have been asked to "rotate" the Certs and Keys for a given database and the only way I knew of to accomplish this was to unencrypt the data first, using DECRYPTION BY CERTIFICATE, create ...
4
votes
1
answer
2k
views
Database master key and certificate for backup encryption - SQL Server
I'm trying to understand backup encryption and I have created a master key (in the master DB) and used a password as follows:
USE master;
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'test123!';
GO
...
- 349
0
votes
0
answers
108
views
Azure Elastic Job step to a privatelink sqldatabase target fails with "target principal name is incorrect" (Trust Server Certificate works in SSMS)
My first Elastic Job Agent jobstep to a privatelink sqldatabase target fails with "target principal name is incorrect." I can connect to servername.privatelink.database.windows.net and the ...
- 41
0
votes
1
answer
404
views
How to query which users are using which certificates in SQL Server?
I would like to know which users a certificate is used by. I tried to do this query but got no results:
SELECT
master.sys.sql_logins.name,
sys.certificates.name
FROM
master.sys....
- 155
0
votes
1
answer
285
views
Install PFX certificate on SQL 2008 R2
We have a MS SQL 2008 R2 service running on a Windows 7 computer. I've developed a webapplication that runs on a Digital Ocean droplet. This droplet makes a connection with this computer through a ...
- 103
2
votes
1
answer
3k
views
How to configure TCPS in JDBC thin client for oracle
An Java Application running with JDBC thin wtih TCP connection, Now require is to convert in TCPS for encryption transmission from application to database.
String url = "jdbc:oracle:thin:@(...
- 121
3
votes
1
answer
713
views
What Microsoft DBA certificate should I acquire?
I am thinking about getting Microsoft DBA certification, but trying to find out which exactly certificate should I study for gets a little confusing.
My company uses on premises SQL Server 2017 but ...
- 637
1
vote
2
answers
625
views
Why would I download CA certificate when starting a managed Postgres cluster on DigitalOcean?
I am trying for the first time a Postgres cluster provided as a managed service by DigitalOcean.com.
As part of configuring the new cluster, their web interface gives me a user name, password, port ...
- 9,656
0
votes
1
answer
1k
views
psql command, how to enforce certificate check?
I have created a cockroachdb v20.1.0 cluster based on this: https://www.cockroachlabs.com/docs/stable/deploy-cockroachdb-on-premises.html
I have also created a test user like this:
CREATE USER test ...
- 393
2
votes
1
answer
883
views
How to get certificate expiration date for certificate in mirroring endpoint in SQL Server 2016 Always On Availability Group?
I created a domain-independent 2-node SQL Server 2016 Always On Availability Group using the Microsoft instructions:
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/...
- 155
2
votes
1
answer
221
views
ola-hallengren backup solution with encryption is not encrypting
Installed OH's scripts and they run great. sqlserver 2017 standard edition in a testing/dev environment. testing before rolling out to production.
I did a test of a restoration of an encrypted, or so ...
- 41
0
votes
1
answer
70
views
Recreate a Certifcate Encrypted by Password to another database
I have created a stored procedure which requires permissions across a number of databases:
USE MyDB;
CREATE PROCEDURE dbo.MyProc
(
@ScheduleName NVARCHAR(260),
@KeepSchedule BIT = 0
)
AS
...
- 1,581
0
votes
2
answers
3k
views
need help understanding the error-message: Error Connecting to database FATAL : no pg_hba.conf entry
We're trying to connect to a postgres/postgis installation on a remote server, using QGIS-Application. When accessing from another pc or from the same pc via pgadmin4v4 with the same credential/...
- 25
0
votes
1
answer
673
views
SQL Server - Add signature to stored procedure by certificate does not work
I have a stored procedure in Database 1 that updates couple of tables in Database 1 and Database 2
To avoid granting calling login/user permissions to do table updates, I try to use code signing
...
- 4,992
0
votes
1
answer
590
views
SQL Server MCSA Database Administration Certification retires on June 30, 2020 - is there going to be a replacement? [closed]
Looking at exams 70-764 and 70-765
This exam retires on June 30, 2020. A replacement exam may be available. To learn more, visit our blog: https://www.microsoft.com/en-us/learning/community.aspx ...
- 4,992
1
vote
1
answer
652
views
SQL Server Encrypted Connections - Configuration Manager does not see Certificate
My goal is to implement encrypted connections on Test SQL Server instance
First, tried to create self-signed certificate in the Certificates snap in (certlm.msc), Personal > All Tasks > Request New ...
- 4,992
0
votes
0
answers
1k
views
Setup certification for SQL Server running on Debian
I have successfully setup an instance of a SQL Server 2017 instance on the latest Debian release, and a domain that points to that server, and I have gotten the respective certificates by using ...
- 166
0
votes
0
answers
119
views
SQL Server - How to know to which database user certificate is mapped to?
Inside a user database, I have two certificates, both are used for signing stored procedures
First cert was created long time ago by someone
Second I created myself for testing purposes
For ...
- 4,992
1
vote
2
answers
1k
views
SSMS login by external developers
This is my first question so please bear with me !
We have an external company whose developers need to login into an instance on our on-premise SQL Server 2016.
They have AD logins, and these are ...
- 11
1
vote
1
answer
5k
views
How to generate a self-signed SSL certificate for MS SQL server 2008 R2 using OpenSSL?
Using OpenSSL, I'd like to generate a self-signed certificate for usage with Microsoft SQL server 2008 R2. This might be unusual, but I'd like to learn what's going on behind the scenes.
I have ...
- 121
0
votes
1
answer
247
views
Grant User permission to view XE results via sys.fn_xe_file_target_read_file
I need to grant a user (MyDomain\JohnSmith) permission to view one particular XE session results using sys.fn_xe_file_target_read_file
I thought the best way to do this would be to encapsulate the ...
- 1,581
6
votes
1
answer
298
views
Permissions issue in Docker SQL Server 2017 while restoring certificate
Docker SQL Server 2017 container @latest. Using master database.
The error I am facing is the following:
[S00019][15208] The certificate, asymmetric key, or private key file is not valid or does not ...
- 123
2
votes
1
answer
848
views
SQL Server Encryption with "localhost" certificate
Using SQL Server 2014/2016:
I'm trying to encrypt my connections from my application to my local SQL Server instance. As I read the documentation, SQL Server seems to very much prefer certificates ...
- 123
0
votes
1
answer
158
views
Force Client to Validate SSL Certificate?
When SQL Server uses the Force Encryption with value "yes" then if in the client-side we use encrypt=true option in the connection string, then the client application tries to verify the server ...
4
votes
2
answers
1k
views
SQL TDE and Certificate Handling Recommendations
I've seen the information on this post: But I don't think it answers this particular question/concern:
I have multiple SQL servers with multiple databases. We want to use TDE on a few of them.
...
- 41
2
votes
1
answer
150
views
Is SQL Server Certificate using asymmetric encryption internally?
In Books Online I've read that both asymmetric key and certificates use the idea of asymmetric encryption. For the asymmetric key it's clear, but do the certificates created in SQL Server or let's say ...
- 2,078
0
votes
1
answer
220
views
Domain Certificate Authority Generated Certificate and SQL Server - Keyset does not exist
I do not have much experience with certificates or certificate terminology, so I may be incorrect in how I title things.
I am trying to use a domain issued certificate as the certificate used in the ...
- 169
1
vote
1
answer
856
views
Having a backup of the master key, how can I restore a database that was encrypted by master key?
while setting up AlwaysOn - Availability Group on a test system,
I generated all the restores from live and restored them to this new server.
then I backup all these databases to a network share to ...
- 15.2k
5
votes
2
answers
738
views
Changing a certifcate+key algorithm by dropping & recreating with the same names
We have a situation where a symmetric key has been created (a long time ago) using TRIPLE_DES. This is used to encrypt a password column, and is used by around ten stored procedures (that utilizes ...
- 778
0
votes
0
answers
80
views
Do I need client or server cert for mySQL master/master replication?
WE use pkitool to sign any certificate using our own CA and there are two options to sign a certificates:
using --sign, which creates a client-cert
Using --server, which creates a server-cert
The ...
- 101
0
votes
0
answers
37
views
How to convert native date value column in a pivot
OPEN SYMMETRIC KEY TblUserDefinedFieldKey DECRYPTION BY CERTIFICATE mDNACert
SELECT * FROM
(
SELECT u.public_id, u.instance_id, u.state, u.tag, udf.name AS [user_defined_key],
CONVERT(NVARCHAR(...
1
vote
2
answers
2k
views
How to set up signed SSL Root and Leaf certificates on a PostgreSQL 11 database on Ubuntu and Windows 10 Power BI plus PostgreSQL?
I have Power BI and PostgreSQL 11 installed on Windows 10 and my primary PostgreSQL 11 database on Ubuntu 18.10 Linux. I edited the postgresql.conf and pg_hba.conf files correctly to the IP Adresses ...
0
votes
1
answer
2k
views
How do I debug/set up MariaDB SSL connection?
[ I originally posted this on ServerFault but then was pointed at this community ]
Since moving from MySQL to a newer MariaDB installation on Debian 9, I a struggling with SSL connections.
I have ...
- 101
2
votes
1
answer
97
views
Creating encrypted backups inhouse to be restored at client
I am trying to understand the mechanics of database backup encryptions, but there are some issues, which I can't seem to wrap my head around. I have 2 requirements:
I need to be able to create and ...
1
vote
1
answer
76
views
Is it possible to login to an Oracle schema using a certificate?
The question is based on having to deal with lots of automated processing (testing, mostly). As it stands, all the schemas used have the same well known password, which is stored in lots of ...
- 197
1
vote
0
answers
373
views
SSL certificate for MS SQL Server
I'm trying to implement SSL certificate on a SQL Server and I already tried two methods. I tried with lets encrypt service and self certificate generated on Powershell.
In the first scenario I can ...
