How do I troubleshoot the clienst end of SQL Server after installing Windows XP SP2?

Source: Internet
Author: User
Tags connect window client port number firewall
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!




Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.