The operating system is windowsxp + SP2, after the installation of MSDE2000, from other machines to connect to the database of this machine, unable to connect.
To see the Run-->cmd-->netstat-a-N, the port of the listener is not 1433 ...
Surf the internet for a bit, got a solution, share: ^_^
01. First run the Cliconfg.exe (SQL Server Client Network Utility),
See if the Enable protocol has TCP/IP and Name Pipes two items, if not, then add;
02. If these two items are already enabled, run the command svrnetcn.exe (SQL Server Network Utility),
See if TCP/IP is added to the Enable protocol.
(Note: After installing MSDE2000, Cliconfg.exe and Svrnetcn.exe are there?) )
03. If this is already on the right of the Enable window, then look at the TCP/IP properties, whether the port is 1433,
Note: Do not pick up the checkbox below when adding TCP/IP at this time;
04. After all this is done, restart SQL Server in Service Manager.
------------------------------------------------------------------------------------------2.----
Open port 1433 in the firewall
Start---> Setup---> Control Panel--->windows firewall---> Exceptions--->
Add Port---> (name: XXX; port number: 1433)---> (tcp;udp)
After loading the MSDE2000, the 1433 port does not listen to the question [collate]