How to solve the WINDOWS XP SP2, the ClienSt end cannot connect to SQL Server?

xiaoxiao2021-03-06  61

After installing WIN XP SP2, the default Windows FireWall is open, so your other client is unable to connect to this SQL Server, you first have to confirm that the unit can be connected, you can refer to the following configuration: 1. In Win The connection protocol running Server Network Utility on XP is TCL / IP. The port is 1433. Be careful not to select Hide Server.2. After configuring, you must restart the SQL Server service. 3. Configure the client's client network utility. Configuring the default connection protocol for SQL Server is TCL / IP. The port is 1433.4. Open Win XP Windows FireWall configuration window, open Exceptions. The first method is to select Add Programm, then select

/sqlservr.exe,

Then select this program, then re-SQL Server service, then the client can connect.

When the second method, select the add port, input 1433 in the port number, enter SQL Server in the NAME

TCP, then select this program, then the client can be connected.

5. Of course, if you choose Windows FireWall Disnable, SQL Server is definitely available!

转载请注明原文地址:https://www.9cbs.com/read-119430.html

New Post(0)