Windows could not start SQL Server Error Code 100048

So SQL Server on my dev machine is not running. I think this machine did an update today and when I came back it was restarted.I don’t use SQL Server on my laptop not unless I am doing development outside of the office so my SQL Server Service is set to start manually.

Tried starting the SQL Server (MSSQLSERVER) service  manually using services.msc but there are errors: Windows could not start the SQL Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 100048.


So it says check event viewer (eventvwr) for the details:


Yeah, there are some errors! Checked one by one saying check the previous error so I did. Says TCP port 1433 is already in use. We all know that port 1433 is used by SQL Server. See: 


Lets terminate that process so that using 1433. Lets check using netstat.

Open a command prompt using Administrator (Run as Administrator) and type: netstat –a –n –o | findstr 1433


Take note of the process ID. It is the number at the right most column. Take note of it and terminate it. Use:

taskkill –pid <ID>


taskkill –pid 7372 as seen in my example.

Now after terminating / killing the process, switch back to the Services console and start SQL Server.


You should be able to log-in in SSMS 🙂


Okay now, back to work!


Published by


I'm John and in the daytime I am the Chief Technology Officer of VFTS.NET - a consulting firm that specializes on development and deployment of business solutions created with .NET framework on Windows platform and Windows infrastructure projects. I am a core member of the Philippine Windows Users Group, a contributor at the Microsoft Philippines Community forums and I regularly conduct technical sessions as well as other Microsoft technology events. I am a Microsoft Most Valuable Professional in the Cloud and Datacenter Management Technical Expertise but away from any keyboard I spend hours reading books, travel, explore, and being busy with my dog named Floppy.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s