cant start sql 2000 on port 1433

for some reason i dont get any errors, but i believe that my server is
not running on port 1433. the tcpip protocol is selected in the
network configuration utility as well as name piper. the port
selected is 1433. but when i telnet to 1433 i get the same errors as i
would if i telnet to a non existant port. i also tried nbstat with no
luck. what else can i do? thanks"Joseph" <jcharth@.hotmail.com> wrote in message
news:2f2b8b0b.0407100759.56318482@.posting.google.c om...
> for some reason i dont get any errors, but i believe that my server is
> not running on port 1433. the tcpip protocol is selected in the
> network configuration utility as well as name piper. the port
> selected is 1433. but when i telnet to 1433 i get the same errors as i
> would if i telnet to a non existant port. i also tried nbstat with no
> luck. what else can i do? thanks

Are you using MSDE, by any chance? Network access is disabled by default
from SP3 onwards:

http://support.microsoft.com/default.aspx?kbid=814130

If that doesn't help, then this article covers other possibilities:

http://support.microsoft.com/defaul...306&Product=sql

Simon|||thanks i found the problem i had to install it in another computer that had sp3

can't log in with MS SQL Web Data Administrator

Installed MSDE with the SAPWD parameter. Installed the MS SQL Web Data
Administrator, started Cassini on port 81 since it didn't like port 80.
Can't get the login to work at http://localhost:81/webadmin/default.aspx. I
keep getting "Invalid username and/or password, you are using a windows
login that is not your own, or server does not exist.". For the machine name
I tried (local), localhost, and my machine's network name, for the login I
tried the sa SQL login and my Windows login. Nothing's working. I'm
obviously doing something wrong, anyone want to clue me in?
BTW my machine is XP Pro.
TIA,
Paul
I have the same problem. Anyone any ideas?