When I use SQL Server 2000 Enterprise Manager, "Enter the database server IP address when the new SQL Server 2000" Enterprise Manager "-> New SQL Server 2000" Enterprise Manager "-> When the registration failed, I was notified did not find the database server I specified. In the upper right corner of the registration box, the small button (that is, the button on the right side of the server IP address bar) is selected to select the database server in the LAN, but found that the server name is not! I am also a person who has installed N SQL Server 2000 database servers, which actually encounters this problem! Depressed for 2 months. I suddenly remembered, SQL Server 2000 servers, didn't hit SQL Server 2000 SP3 patch, hurry up, solve the problem!
This discovers that the SQL Server 2000 service is installed on Windows 2003, you must hit the SQL Server 2000 SP3 patch, otherwise it is not available at all. In the past, I used to install SQL Server 2000 on Windows 2000 Server, and I could poison it without patch. I would like to be patch, but I don't care whether I don't play patch, the client SQL Server 2000 "Enterprise Manager" went to build SQL Server registration is very convenient. Perhaps Microsoft is for system security considerations. Also said, the client connects the unpatched SQL Server 2000 server on Windows 2003, does not enter the IP address, and the direct input server name can be registered and create a database and table. I always can't think that this is the vulnerability of Microsoft's unbearable?
