Friday, January 25, 2008
SQL Server 2005 Surface Area Configuration Tool
SQL Server 2005 SAC (Surface Area Configuration) helps you configure your services and settings. It allows you to easily configure security settings for all of your database instances.
From here you can also configure and setup all of your services. The big one to pay attention to is the Remote connections, buy default every edition except for enteprise does not listen for remote connections over TCP/IP.
SQL Server Browser Service
This service is important especially if you are connecting from a remote computer, otherwise you may get the dreaded "SQL Server does not allow remote connections" error.
A good reference was on this page: