Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Error While starting SQL Server 2000

 
   Database Forums (Home) -> Connect RSS
Next:  Create Text File and insert it into database  
Author Message
mujeeb




Joined: Feb 05, 2005
Posts: 2



(Msg. 1) Posted: Sat Feb 05, 2005 6:41 am
Post subject: 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

 >> Stay informed about: Error While starting SQL Server 2000 
Back to top
Login to vote
Mike Epprecht

External


Since: Jul 10, 2004
Posts: 175



(Msg. 2) Posted: Sat Feb 05, 2005 7:40 pm
Post subject: Re: Error While starting SQL Server 2000 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 DeleteThis @epprecht.net

MVP Program: <a style='text-decoration: underline;' href="http://www.microsoft.com/mvp" target="_blank">http://www.microsoft.com/mvp</a>

Blog: <a style='text-decoration: underline;' href="http://www.msmvps.com/epprecht/" target="_blank">http://www.msmvps.com/epprecht/</a>

"mujeeb" wrote in message

 > 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 <a style='text-decoration: underline;' href="http://www.dbforumz.com" target="_blank">http://www.dbforumz.com</a> interface, at author's request
 > Articles individually checked for conformance to usenet standards
 > Topic URL:
<a style='text-decoration: underline;' href="http://www.dbforumz.com/Connect-Error-starting-SQL-Server-2000-ftopict195117.html" target="_blank">http://www.dbforumz.com/Connect-Error-starting-SQL-Server-2000-ftopict...117.htm</a>
 > Visit Topic URL to contact author (reg. req'd). Report abuse:
<a style='text-decoration: underline;' href="http://www.dbforumz.com/eform.php?p=660630" target="_blank">http://www.dbforumz.com/eform.php?p=660630</a><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Error While starting SQL Server 2000 
Back to top
Login to vote
mujeeb




Joined: Feb 05, 2005
Posts: 2



(Msg. 3) Posted: Sun Feb 06, 2005 3:07 am
Post subject: [Login to view extended thread Info.]

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
 >> Stay informed about: Error While starting SQL Server 2000 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL Server 2005 (MSDE) delay after starting services - After starting the SQL Server Desktop Edition 2005 service, I can't connect to it for a matter of up to 10 seconds (I get an authentication failure). This is causing a problem in my dependent services, because they then fail even though SQL Server is..

SQL Server 2005 (MSDE) delay after starting services - After starting the SQL Server Desktop Edition 2005 service, I can't connect to it for a matter of up to 10 seconds (I get an authentication failure). This is causing a problem in my dependent services, because they then fail even though SQL Server is..

RPC error -Link server from MSSQL 2005 (32 bit) to MSSQL 2.. - Hi, Server A is having mssql 2005 (9.0.1399) while server B is having mssql 2000 (8.9.2187). When a job is scheduled to transfer data from server A to B via linked server, there is an error - 'Server B is not configured for RPC. [SQLSTATE 42000]..

SQL Server 2000 linked server problem - This is SQL Server 2000 sp3a. I have linked servers that have been working for a fairly long time. If I am on the server (TermSvc), I cann connect and test through the linked server successfully. If I am initiating this from any workstation or..

Tracing SQL Server 2000 Connections - Hi We're experiencing connection timeouts when the C drive of our SQL Server is backed up to tape. Backup Exec and native Windows Backup have both highlighted/caused the connection timeouts which last for around 90 seconds at the end of the backup....
   Database Forums (Home) -> Connect All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]