Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


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.

share|improve this question

migrated from Aug 27 '13 at 20:26

This question came from our site for system and network administrators.

Have you researched 'creating a self signed certificate'. There should be plenty of tutorials online for this. – Drew Khoury Aug 27 '13 at 14:31

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.