SQL Server Surface Area – Quick Tip

Posted on November 28, 2006 by Andrew Woodward

One of those quick posts that will save me a few hours in a couple months time. If you install SQL Server 2005 Developer Edition it is configured by default to only allow local connections. Testing in ODBC connections from the remote server will show:

Attempting connection

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

To change this you need to allow local and remote connections.

Start -> Program Files -> SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration

Enable Local and Remote Connections and use TCP/IP (recommended), or other if your environment requires.

sql surface areap>

Restart the SQL Instance.

 

This entry was posted in Development, Random Stuff and tagged . Bookmark the permalink.