How do I make sql server 2000 desktop engine...

[trist007]

open to network connections? I installed msde2000.exe on default instance and it is running in the system bar with the green play on it. Yet, when I pull up netstat -a, nothing shows up. I also tried, setup SAPWD="XXX" DISABLENETWORKPROTOCOLS=0 and still ports 1434 udp and 1433 tcp were closed. How do I configure sql server 2000 desktop engine to use those ports?

I am aware of the security vulnerability.

I am using the msde2000.exe v8.00.194 on a windows xp pro sp3 os

I've been looking at the netstat -a output and there's stuff that is connecting to some wierd websites. How do I shut those ports down? Also, is there a command in the cmd shell to display all services with ids so I can kill or stop some. Also, I dont have the kill binary, where can I download it, would I have to compile it or do I just copy it to the windows\system32 dir?

 

[trist007]

bump

 

[trist007]

bump

 

[jdean]

Instead of netstat and kill, I would suggest that you get a good firewall and configure it to run in "learning mode" where it prompts you on new connections. I use Sunbelt Personal Firewall (the free version) and it works quite well for this purpose.

I don't know about SQL Server but surely you can Google and find something. For example, I did a quick search and came up with this article:

http://www.aquafold.com/docs-register-msde.html

I certainly don't want to discourage you from using the forums here, but when I have a question like this, I find that I can get it answered faster by doing a search than I can by posting a question. I use the forums when I can't find an answer.

Hope you find this helpful...