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.

 

Errorindicate 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