Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
judy
Starting Member
2 Posts |
 Posted - 2006-07-20 : 13:44:06
|
| Hi, I am trying to install MS SQLserver 2000 on my windows XP professional. On my laptop, the installation ended with success. From Windows Services, the server is started. And if I go to Enterprise Manager, I can see the default server with the machine name. However, if I do "netstat -a", I can not find the port 1433 listening. I already confirm that "tcp/ip" is the protocol for the server and port is 1433 from the server properties. Aslo, if I go to the logs under installation directory, the line "server is listening on <host>:<port>" is missing although the line "Server is ready for client connection" is there. No noticeable error is found in the log. I have tried to intall to a different directory and it does not work. If I install it on another machine (W2K), there is no problem. My laptop does have some virus/spyware problem. I need to clean it up. But would that be related to the current installation problem? Thank you for your help in advance.Ariana |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-07-21 : 00:56:03
|
| My first guess would be that you have XP SP2, and you haven't applied any service packs to the SQL Server install.To help stop any outbreaks of the SQL Slammer worm, XP SP2 won't let SQL Server bind to TCP if you haven't brought it up to at least SP3.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
judy
Starting Member
2 Posts |
Posted - 2006-07-21 : 15:22:19
|
| Hi Damian, You are absolutely right! The problem is fixed after I installed SP4 for SQLServer. Thank you so much!Ariana |
|
|
|
|
|
|
SQLServer 2000 installation problem