Solution for error when connecting SQL Server to server

The solution for establishing a connection with the server in SQL Server is as follows:

Step 1: Enable remote connection on SQL Server instance

1 Point to "Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Peripheral Application Configurator"

2. On the "SQL Server 2005 Perimeter Application Configurator" page, Click "Services and Connected Perimeter App Configurator"

3. Then click to expand "Database Engine", select "Remote Connection", and select "Local Area Connection and Remote Connection" on the right side,

Select the protocol to use again (this place should enable TCP/IP and Named Pipes!) Click on "Apply" and you will see the following message:

"After restarting the Database Engine Service , the changes made to the connection settings will not take effect.", click the "OK" button to return to

4. Expand "Database Engine", select "Services", click "Stop" on the right, wait until MSSQLSERVER The service stops,

and then clicks Action "to restart the MSSQLSERVER service.

Step 2: Enable SQL Server Browser Service

1. Point to Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Peripheral Application Configurator

2. On the SQL Server 2005 Perimeter App Configurator page, click Services and Connected Perimeter App Configurator

3. Then click to expand SQL Server Browser. Select "Service", select "Automatic" on the right "Startup Type",

Click "Start", click "OK" button to return to

Step 3: In Windows Firewall Create an exception for "SQL Server 2005"

1. In the Windows Firewall Settings interface, select the "Exceptions" tab, then click "Add Program"

2. In the "Add Program Window" Click "Browse"

3. Then find "C:\\Program Files\\Microsoft Files\\Microsoft SQL Server\\ MSSQL.1 \\MSSQL\\Binn\\sqlservr.exe",

单Click "OK" to return

Note: The path may vary depending on the SQL Server 2005 installation. MSSQL.1 is a placeholder for the database instance ID.

4. Repeat steps 1 through 3 for each instance of SQL Server 2005 that needs to open remote access.

Step 4: Create an Exception for "SQLBrowser" in Windows Firewall

1. In the Windows Firewall Settings screen, select the Exceptions tab and click Add Programs

2. Click "Browse" in the "Add Program Window"

3. Then find "C:\\Program Files\\Microsoft Files\\Microsoft SQL Server\\90\\Shared\\sqlbrowser.exe",

Click "OK" to return to

Note: The path may vary depending on the SQL Server 2005 installation.