server|window| resolves that the default Windows Firewall is open after the win XP SP2 is installed, so your other client is not
To connect to this SQL Server, you first have to make sure that the computer can be connected, you can refer to the following configuration:
1. The connection agreement that runs the Server Network Utility configuration SQL Server on Win XP is TCL/IP and the port is 1433, and be careful not to select Hide Server.
2. Restart the SQL Server service after the configuration is good.
3. Configure the Client Network Utility, the default connection protocol for SQL Server configuration is TCL/IP,
The port is 1433.
4. Open the Windows Firewall Configuration window for Win XP and open exceptions.
The first method is to select Add Programm and then select Qlservr.exe,
Then select the program and then restart the SQL Server service, and then the client can connect.
The second method selects add port, enters 1433 in port number, and enters SQL Server in name
TCP, and then select the program, and then the client can connect.
5. Of course, if you choose Windows Firewall disnable,sql Server is sure to be able to connect on!
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.