Friday, May 14, 2010

Exposing SQL Server to remote connections

Exposing SQL Server to remote connections


This one is really easy but can make you crazy if you can't figure it out, and the SQL documentation isn't much help. When you set up the server, you need to go into "Configuration Tools", then "SQL server surface area configuration". Then go into Remote Connections, then select Local and Remote Connections. This will expose the server to other servers or to the internet if on a web server.

No comments:

Post a Comment