Solution to SQL Server 2005 error when establishing a connection to the server

When you open a newly installed web site, the following error is displayed:

An error occurred while establishing a connection to the server. When you connect to SQL Server 2005, this failure may be caused by SQL Server not allowing remote connections under the default settings. (Provider:sql network interface, error:26-error locating the specified server/instance)

Solution:

1. Select "TCP/IP only" on the "Perimeter Configuration" tool.

2. Then from the "Configuration Manager" to find "... 2005 Network Configuration "->" network protocol-> "TCP/IP" to see the port number inside, the default is 1433, you can change into your favorite.

3. If there is a firewall, but also in the corresponding firewall add an exception, such as the default of 1433 so you can connect remotely.