It took several years of Windows2003, and it took many years to SQL Server, but this was the first time the problem was encountered. Afternoon friends encountered a phenomenon, in the Win2003 Simplified Chinese server version of the installation of SQL Server2000, the default installation, everything is normal, but after the installation is completed to view the port, 1433 port incredibly not open, of course, not to mention remote connection.
The general analysis is this:
1, the SQL Server service did not start;
Check service startup, reboot service failure still.
2, modified the port number;
Open the Network Utility, check the TCP/IP protocol in the enabled Protocol, and view the port, 1433 yes.
3, the client utility has made the change;
Open the client utility, check the protocol port is normal, recreate an alias, still not.
4, the installation of the problem;
There is a problem with the installation steps because there is no way to see how he installed the SQL. According to Zhang Ye this cow, if you modify the default instance name, but not properly configured, this behavior occurs. So unloading load, all default, fault still.
5, installation version of the problem;
Viewing the installation CD is a time-tested installation disk and should not be problematic.
6, the problem of the system;
Can not see what other problems, is the system of the problem? But reloading the system can be too much trouble, or think of other ways to see if you can find the problem.
Check the system log, this should be a better habit. After a careful look over the reinstall log, impressively found the following:
The Microsoft SQL Server 2000 version you are running or Microsoft SQL Server Desktop Engine (also known as MSDE) and the Microsoft Windows Server 2003 family Enable A known security vulnerability exists. To reduce the computer's attack by some viruses, the TCP/IP and UDP network ports for Microsoft SQL Server 2000,msde or both are disabled. To enable these ports, you must from http://www.microsoft.com/sql/downloads/default.asp or http://www.microsoft.com/china/sql/downloads/ Default.asp Install a hotfix, or the latest service pack for Microsoft SQL Server 2000 or MSDE.
For more information, see Help and support in http://go.microsoft.com/fwlink/events.asp
Finally found the problem, it turned out to be a small security consideration for Windows. So why have not met before, the original used to secure the people, install the SQL, in the use of the first will fix the loophole, so has not been noticed this problem. It seems that any habit will have some drawbacks!
Now that it's easy to find the problem, everything is fine after installing SQL Server SP4.
From the above question we come to the conclusion that:
1, do not inertia thinking;
2, to see more Microsoft wrote the log, in fact, Microsoft has done better than imagined much better;
3, everywhere to pay attention to knowledge ah;