Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition
You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:
Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.
Note Click OK when you receive the following message:
Changes to Connection Settings will not take effect until you restart the Database Engine service.
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.
MSSQL Server 
2011, 2012, abhilash, Apply, Area, click, click service, computer, configuration, configuration tools, connection, connection settings, database, database engine, Developer, developer edition, Engine, Express, instance, message, microsoft, microsoft sql server, microsoft sql server 2005, MSSQLSERVER, mssqlserver service, page, programs, protocol, Remote, remote computer, server, Settings, SQL, sql server 2005, sql server 2005 express, START, Stop, Surface, surface area, Tools
Meet Author
S.Abhilash, started this blog in the later half of 2009 as a self hosting site for all his previous blogging attempts. , My way of writing and frequency of publishing may not be uniform as my resources are my projects nd issues i came across. For the last few years this blog is reacing 100 s of unique visitors each day, thanks wordpress and google for such a perfection in their software and services.
Submit Your Email For Free Updates on New Articles