Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

Connection string Data Source = 192.168.1.2,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
add comment

1 Answer

up vote 1 down vote accepted

I believe certificates are the way to go, and it seems to be documented nicely here: http://support.microsoft.com/kb/316898

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

Your Answer

 
discard

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.