SQL 2000 server TCP bind problem

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

From: mmazick (anonymous_at_discussions.microsoft.com)
Date: 09/08/04 

Date: Tue, 7 Sep 2004 17:28:27 -0700

I am running SQL 2000 sp3. I am getting an error in the
log files that states the SQL server "can not bind to
TCP: port 1433"

I can not find much info on this other than what is in
the log files. It appears that the server errored last on
an integrity check of the SQL master db.

Is there a recovery utility available that will recover
or rebuild the master database?

Thanks for the help....

Relevant Pages

  • Re: Using findstr on SQL 2005 ERRORLOG file
    ... are Unicode or some format that findstr cannot parse properly. ... I see the checkbox on the SQL Agent's for "Write OEM File", ... a plain ANSI text file format for log files? ... I doubt there is a setting to force the SQL Server error log to be ANSI. ...
    (comp.databases.ms-sqlserver)
  • Re: SPS - SQL Server - LOG FILES.
    ... you should have your DBA help you with removing and shrinking the files as you can't simply delete them (SQL will startup again trying to find them and won't create them until something like a CREATE DATABASE command is issued). ... This isn't something I can post in a step-by-step message here as it's a fairly involved process and requires a good understanding of SQL Server. ... these log files are using lot of space on c drive. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: do not display the result of a SELECT
    ... log files, which would make them very large. ... INTO #temp FROM ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: Failed When Installing SQL Server 2005 on Windows 2003 R2 SP2
    ... I have checked and I found 2 error messages in the system log files (be ... opened from event viewer) when installing the SQL 2005: ... The SQL Server service failed to start due to the ... Timeout waiting for the SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving the SQL Database
    ... I think you should reinstall SQL server, you should just move the databases ... and log files to the new partition. ... > I've got SPS2003 installed on the C: with the SQL database on the same ...
    (microsoft.public.sharepoint.portalserver)