2

Environment: Windows 7 Professional x64 in a domain, running SQL Server 2012. I have local admin rights, so messing up the system is easy. My SQL Server instances are SQLEXPRESS and MSSQLSERVER. FQDN should be for example my-pc.mydomain.local.

Problem:

I don't know the right way to setup SSL on this SQL Server. I actually only want to setup SSL with a certificate created of my own.

Can anybody help me out here? Most of the documentation online only describes the way of going through a CA and have different knowleadge as a prerequirement.

marc_s
9,0626 gold badges46 silver badges52 bronze badges
asked Aug 27, 2013 at 11:32
1
  • 1
    Have you researched 'creating a self signed certificate'. There should be plenty of tutorials online for this. Commented Aug 27, 2013 at 14:31

1 Answer 1

2

This blog post details the entire process.

You use IIS manager to create a self signed certificate, then add it through the Certificates MMC for the computer account.

Then give SQL server's service account read permissions on the certificate, and choose the certificate in SQL Server's network configuration in configuration manager.

answered Aug 27, 2013 at 18:36

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.