Friday, February 24, 2012

Error While starting SQL Server 2000

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-Err... />
95117.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz
.com/eform.php?p=660630Hi
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-Err...pict195117.htmlreen">
> Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbforumz.com/eform.php?p=660630|||"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...
> standards
> http://www.dbforumz.com/Connect-Err...17.htm
l
> 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

No comments:

Post a Comment