all groups > sql server connect > february 2005 >
You're in the

sql server connect

group:

Error While starting SQL Server 2000


Error While starting SQL Server 2000 mujeeb
2/5/2005 4:57:46 PM
sql server connect:
Im getting this error when starting the Mssql server 2000
SuperSocket Info: Bind failed on TCP port 1433.
please advise

also note thta it is only MSDE not the whole SQL Sever

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Connect-Error-starting-SQL-Server-2000-ftopict195117.html
Re: Error While starting SQL Server 2000 Mike Epprecht (SQL MVP)
2/6/2005 1:09:18 AM
Hi

Looks like something else is listening on port 1433 by the time you are
trying to start the service.

Before you start MSDE, run "NETSTAT -a"to see what is listening on 1433.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]
http://www.dbforumz.com/eform.php?p=660630

Re: Re: Error While starting SQL Server 2000 mujeeb
2/6/2005 12:37:38 PM
[quoted text, click to view]

I did all that and the netstat part of output is here

TCP 193.9.200.243:1361 193.9.200.244:139 TIME_WAIT
TCP 193.9.200.243:1363 193.9.200.51:139 TIME_WAIT
TCP 193.9.200.243:1383 193.9.200.244:139 TIME_WAIT
TCP 193.9.200.243:1433 0.0.0.0:0 LISTENING
UDP 0.0.0.0:135 *:*
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:1026 *:*
UDP 0.0.0.0:1434 *:*

AddThis Social Bookmark Button