Hello,



This one is mostly for Ben I guess since we discussed this in some length at the seminar.



I am looking for some help in exposing my SQL Server 2005 to the internet for development of the "smart client" app we talked about. I looked around for some articles but didnt find exactly what I was looking for. Can you point me in the right direction? I did talk to my dedicated server provider and they said "No problem, we will take care of it" once I go into production they will handle the security aspects. What I need right now is to get my in-house SQL 2005 server exposed for development and testing purposes in a relatively secure manner.



Thanks,



Keith

Keith Chisarik

What version of SQL Server is it?  The TCP/IP connectivity is going to vary depending upon the version.

However, no matter what the version, you'll want to configure a user on the SQL Server that you will use to connect from the remote clients.  Disable the 'sa' account and add some other account that is the sysadmin for the server.

You'll also want to append "Encrypt=True;" to the end of your connection string to make sure the data is encrypted to and from SQL Server.