Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SSL Connection

Author  Topic 

GregDDDD
Posting Yak Master

120 Posts

Posted - 2012-03-19 : 11:39:00
We have an instance of SQL Server 2005 running and I have written a Visual Studio 2010 application which reads and writes to it. This application is in-house only and no one outside of our domain access the database.

I've been asked to explore the possibilities of running the application outside of our facility by users who are not on our domain. I've been reading about enabling SSL encryption. If I import a certificate and enable SSL connections on the instance does that mean that all connections now must use SSL connections?

Also, and this question may be outside the scope of this forum, but I assume I would still need to have the db server visible to the outside world. Is this correct? Would I change firewall settings so the outside world could see the IP and port the SQL Server is running on? This is new to me, but am I heading in the write direction with my thinking on this.

Greg
   

- Advertisement -