Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : General : SQLServer

Enable remote connections for SQL Server 2005

If u could not able to connection MSSQL EXPRESS 2005 through remote then kindly follow the steps given below to get connect.

Enable remote connections for SQL Server 2005 Express or SQL Server 2005. You must enable remote connections for each instance of SQL Server 2005 that you want to connect from a remote computer.

To do this, kindly follow the steps given below:

1. Click Start ->Programs -> Microsoft SQL Server 2005 ->Configuration Tools ->SQL Server Surface Area Configuration.

2 On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.

3. 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.

a. Note Click OK when you receive the following message:

b. Changes to Connection Settings will not take effect until you restart the Database Engine service.

4. 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.

Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB