Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

I have configured the instance of SQL Server to allow dedicated users to access it remotely.

Connection string Data Source =,1433\sqlexpress;etc... has been tested and works.

However, I have not configured the SSL to secure the communication.

How to configure SSL on an instance of SQL Server to allow dedicated users to remotely access it?

edit 1

The dedicated user will administer its database using Sql Server Management Studio. What I want to do is to secure the communication when he/she administers the database using Sql Server Management Studio.

share|improve this question
up vote 1 down vote accepted

I believe certificates are the way to go, and it seems to be documented nicely here:

Ideally, the users should connect to the app server (web?), and the app server should be the only device connecting to the database server. This makes it easier to secure, and easier to implement things like encryption over the network.

I would also imagine that you can encrypt the traffic from app server to database server on the chosen port by IPSEC or similar.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.