Environment: Win7 32-bit
Database: sqlserver2005
Error process:
Follow the sqlserver2005 default process step-by-step installation, the previous boot has been normal,
To start the sqlserver2005 of the native installation today, click "" Login, Error message: The following:
Title: Connecting to a server
------------------------------
Unable to connect to XGL.
------------------------------
Additional Information:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or could not be accessed. Verify that the instance name is correct, and that SQL Server is configured to allow remote connections. (PROVIDER:TCP provider, error:0-Unable to connect because the target computer is actively rejecting.) ) (Microsoft SQL Server, error: 10061)
For help information, click: Http://go.microsoft.com/fwlink? prodname=microsoft+sql+server&evtsrc=mssqlserver&evtid=10061&linkid=20476
Baffled,
Baidu Ah, Google to come,
Finally found a solution:
1. First, enter: SQL Server Configuration Manager to ensure that the TCP/IP protocol in the MSSQLSERVER protocol under the network configuration has been started. 2, enter: Start-up program->mssqlserver 2005-> Configuration Tool->mssqlserver 2005 Peripheral Application Server. Under Configure the Perimeter app localhost, click on services and connections for the perimeter application configuration server, select Mssqlserver->database engine-> remote connection, select "Local Area Connection and remote connection" and choose to use both tcp/ IP and Named pipes an entry. Once setup is complete, restart the MSSQLServer service.
3, re-login, OK,
This is how I configured the success, as for why, the reason is looking.
SqlServer2005 provider:tcp Provider, error:0-Unable to connect because the target computer is actively rejecting. ) (Microsoft SQL Server, Error: 10061) Problem resolution