September 19, 2017 at 3:27 am
Hello,
at start sorry for perhaps dumb question but im kinda new to pki/certificates subject in terms of SQL Server.
I would like to verify whatever or not authenticate to SQL Server using PKI/certificates is possible or not? As far as i know it is not possible, at least i couldn't find any information about it. Am i right or perhaps i am wrong? Case is to login from application to SQL Server.
However despite the answer for above topic it is possible to encrypt connection to SQL Server usiing certificates. Does anyone by any chance has some really good articles about subject? I found some on microsoft pages and other sites but if someone knows good ones i would gladly read them.
September 19, 2017 at 9:17 am
Here's the BOL article: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine
We don't have a great article here, but we need one. I'll see if I can get one up. The idea is that you get a certificate, just like you'd get one for an IIS web server, and you install this on your SQL Server. You can set the server to Force Encryption by the client, so clients will need encrypted connections.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply