Re: Re: Error While starting SQL Server 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: mujeeb (UseLinkToEmail_at_dbForumz.com)
Date: 02/06/05 

Date: 6 Feb 2005 12:37:38 -0500

"Mike Epprecht" wrote:
> 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/
>
> "mujeeb" <UseLinkToEmail@dbForumz.com> wrote in message
> news:1109uoa2fg07p33@news.supernews.com...
> > 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
> > Visit Topic URL to contact author (reg. req'd). Report
> abuse:
> http://www.dbforumz.com/eform.php?p=660630

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 *:*

regards

Relevant Pages