Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

share|improve this question

migrated from serverfault.com Aug 27 '13 at 20:26

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

1  
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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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