The SQL Server (SQLinstance1) service terminated with service-specific error 10048 (0x2740)

[Jen]

If the MSSQL service unable to start and received the following error, please refer to the steps mentioned below:

The SQL Server (SQLinstance1) service terminated with service-specific error 10048 (0x2740).

1. Make sure that the remote connections are enabled on the server.
2. Check TCP/IP configurations and make sure that the TCP/IP port is not used by any other applications.
3. Run netstat from the command prompt to check whether port 1433 is listening or you can just execute telnet command to check the port 1433 is listening or not.
Telnet localhost 1433
4.If the port 1433 is in use then most likely that you have one more SQL instance running on the server.
5. If you have 2 SQL instance running on the same server then you will have to use different ports for example: 1434.
5. Use different port and then restart the SQL server, it should work

[Shane P]

Re: The SQL Server (SQLinstance1) service terminated with service-specific error 10048 (0x2740)

Hello Jen,

Thanks for sharing such a useful Error solution...........!!!!!!!!!!