How to enable remote connection on Sql Server 2008

To enable remote connections on the instance of SQL Server 2008, use the SQL Server Configuration Manager under configuration Tools. Go to Start > All Programs > Microsoft Sql Server 2008 > Configuration Tools > Sql Server Configuration Manager.

  • Start Sql Server Browser service, if it is not started. You can set its start mode Automatic using Right click on Sql Server Browser > Properties > Services > Start Mode.
  • Under Sql Server Network Configuration, select your Sql Server Instance and enable the TCP/IP protocol.

For Step-by-Step information with screen shots follow the below links:
1. http://mushtaqnaik.blogspot.in/2010/12/how-to-enable-remote-connection-on-sql.html
2. http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

Suggested links:
Enable Remote Connection on Sql Server 2005

Leave a Reply

Your email address will not be published. Required fields are marked *