Solution to an error in establishing a connection to the server in SQL Servers

The solution for making a connection to the server in SQL Servers is as follows:

The solution for making a connection to the server in SQL Servers is as follows:

Step 1: Enable remote connections on the SQL Server instance

1. Point to start-> program->microsoft SQL Server 2005-> Configuration tool->sql Server perimeter Application Configurator

2. On the SQL Server 2005 Perimeter Configuration page, click the perimeter application configurator for services and connections

3. Then click to expand Database engine, select remote connections, and on the right, select local and remote connections.

Then select the protocol you want to use (this place should enable TCP/IP and named pipe services!) Click Apply, and you will see the following message:

"The changes to the connection settings will not take effect until the Database engine service is restarted. ", click OK to return

4. Expand the database engine, select Services, click Stop on the right, and wait until the MSSQLServer service stops,

Then click Start to restart the MSSQLServer service.

Step 2: Enable the SQL Server Browser service

1. Point to start-> program->microsoft SQL Server 2005-> Configuration tool->sql Server perimeter Application Configurator

2. On the SQL Server 2005 Perimeter Configuration page, click the perimeter application configurator for services and connections

3. Then click Expand SQL Server Browser, select Services, and on the right "startup type" select "Automatic",

Click Start, and then click OK to return

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

1. In the Windows firewall settings interface, select the Exceptions tab, and then click Add Program

2. In the Add Program window, click Browse

3. Then find "C:\ProgramFiles\Microsoft Files\Microsoft SQL Server\ Mssql.1 \mssql\binn\sqlservr.exe",

Click OK to return to the

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

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

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

1. In the Windows firewall settings interface, select the Exceptions tab, and then click Add Program

2. In the Add Program window, click Browse

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

Click OK to return to the

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