How To Enable SQL 2005 For Remote Access

Jul 06, 2006
by:   Tim Stanley

If you have recently installed SQL Server 2005, for security purposes, external and remote access is not enabled by default. If you try to connect to a SQL Server database from an external machine you may see one of the following errors.

  • SQL server does not allow remote connections
  • SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
  • An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server))
  • Server does not exist or access denied

Three steps to Enable SQL 2005 for Remote Access

  1. Enable the TCP/IP protocol using the Surface Area Configuration Utility
  2. Enable the TCP/IP protocol for the network adapter in the SQL Server Configuration Utility
  3. Start the SQL Server Browser

SQL Server Surface Area Configuration

Remote Connections

SQL Server Configuration Manager

References

Add to favorites Send to a friend Digg It! DZone It! StumbleUpon Technorati Reddit Del.icio.us NewsVine Furl BlinkList