ID #1096

SQL Service not getting started

Error : Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use.

Solution : Change the default listening port of sql from 1433 to some other port and try to start the service.

 

Error: indicate data corruption or that the log file (.ldf) does not match the data file (.mdf)

Solution : rename the master.mdf and mastlog.ldf from c:\mssql.1\mssql\data\ and copy both the file from the

                c:\mssql.1\mssql\templatedata\  (Assumed that sql server is installed in c:) and then start the sql service.

Tags: -

Related entries:

You cannot comment on this entry