Re: Cannot bind to port 1433

If your referring to a one off check of what is using a port you can use
tcpview from Microsoft. If your referring to a monitoring system, Id suspect
the easiest way would be to put something together in .net that is run
to start the sql service. It could simply check the port and if its free
then start sql otherwise kill the offending process and start sql server.

-Allen Kinsel


I have an instance of SQL Server that gets recycled every night (SQL
2000 sp4, windows 2000 sp4). Every couple of weeks or so users can't
connect in the morning, and I see in the SQL log the error message 'SuperSocket Info:
Bind failed on TCP port 1433.' When I restart the SQL service, it
seems to clear it up.

I've done some research on this, and it looks like it can be caused by
something else using port 1433. Does anyone know if there is a way to
monitor this port to see if something else is using it?






Posted by NewsLook (Trial Licence) from http://www.ghytred.com/NewsLook/about.aspx



.

Relevant Pages

  • Re: SQL DBA Client
    ... What is required depends on how you expose your SQL... ... measures you should consider are changing the port number ... you're using and using a User account with minimal ... Enterprise Manager accordingly (configuring the Client ...
    (microsoft.public.windows.server.sbs)
  • Re: Merge replication in SQL Server
    ... However, port 443 is for https, did you want your SQL ... Configuring an instance of SQL Server to use a static port ... you can script out replication jobs by right clicking on a publication ...
    (microsoft.public.sqlserver.replication)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... Will anything change when I install SQL 2008 on the laptop? ... Queries to the Data Engine must go to the port that SQL Server is ... More info: How to: Configure a Windows Firewall for Database Engine Access ...
    (microsoft.public.sqlserver.connect)
  • Re: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • SQL Adapter with Map blocks SQL Server?
    ... We have a receive port that executes a stored procedure via an SQL ... XmlReceive/Passthrough as receive/send pipeline and simply dump the XML ... if we specify inbound and outbound maps, ...
    (microsoft.public.biztalk.general)
Loading