Login | Sign Up | iGold Site Search

How to Enable Remote Connection in SQL Server 2005

Unlike SQL 2000 by default connection from remote machine to SQL Server 2005 is disabled. To enable remote connection for SQL 2005 follow these steps. Under SQL 2005 program menu follow configuration Tools => SQL Server Surface Area Configuration => Select "Server Surface Area Configuration for Services and Connections". It will lead to a window with a treeview , select Remote connections node in that tree view.On selection it will provide a list of options, in which select "Select Local and Remote Connections". Now its ready