SQL Server does not allow remote connection.

An error occurred while establishing a connection with the server..ConnectSQL Server 2005In the default settingsSQL ServerRemote connection is not allowed, which may cause this failure..

 

Solution:

1. Make sure that sa exists in the Database on the server and the hybrid logon mode is supported. By default, SAS may be ignored during installation.

 

2. make sure that the database on the server supports remote calls. open SQL Server Management Studio, select the database, right-click the menu "Properties", select Connections in the displayed dialog box, and select Allow remote connections to this server.

 

3. make sure that the TCP/IP of the SQL service on the server is Enable. open SQL Server Configuration Manager. select Protocols for SQL2005 under SQL Server 2005 Network Configuration (the name of the SQL example I installed is SQL2005) and change Named Pipes and TCP/IP to Enabled. The default value is Disabled.

 

4. make sure that the remote invocation of the SQL instance on the server supports TIP/IP and named pipes. open SQL Server Surface Area Configuration Manager, and select Surface Area Configuration for Services and Connections on the page. select Remote Connections of the instance and select Using both TCP/IP and named pipes.

 

5. Restart the SQL Server 2005 service on the Server to make sure that the services of the SQL Server Agent and SQL Server Browser are also started. Manual start is required by default and can be changed to Automatic.

 

6. Because the operating system on the server is WinXp + SP2, check the firewall to ensure that1433PortOpened.

 

In addition, the default port of SQL Server 2005 may not be 1433. we need to modify it manually. open SQL Server Configuration Manager. select Protocols for SQL2005 under SQL Server 2005 Network Configuration (the name of the SQL example I installed is SQL2005) to view TCP/IP attributes. in the displayed dialog box, select IP Address and change the TCP Dymanic Ports under IPAll to 0 and the TCP Port value to 1433.

 

Add Port: TCP 1433 and UDP 1434 in Windows Firewall Exceptions, and Add Program. open SQL Server Configuration Manager, select SQL Server in SQL Server 2005 Services, view properties, and remember the Instance ID in Advanced. for example (Mssql.1)

 

Add Program in firewall Exceptions, find... \ Microsoft SQL Server \ MSSQL.1 \ Mssql \ Binn \ SQLservr.exe, and Add.

 

After all this is done, the Client should be able to access it. It is recommended that the Client set TCP/IP to Enabled in the Client Configuration of Configration Manager.