Management

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 785 other subscribers

Social

  • LinkedIn
  • RSS Feed for Posts
  • Twitter
  • StumbleUpon

SQLEXPRESS : Windows could not start the SQL Server (SQLExpress) on local Computer. Service-specific error code 10048. [SOLVED]

This week I had a SQL installation, on which the SQLEXPRESS service didn’t want to start.

When starting the service I received the error :

Windows could not start the SQL Server (SQLExpress) 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 10048.

 

Solution:

First check the event log for the correct error

So this port is already in use by another application

 

Start your command prompt

Execute : netstat -ab > netstartport.txt

Execute the created text file

Here you find that the problem in this case is the jhi_service.exe file

 

My solution :

I’m going to reserve the used SQL port so this jhi_service.exe can’t use this port.

Start Regedit

Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

Create or edit the key ReservedPorts

In my error in the beginning of this post you’ll see the error was in IP6 and port 49330

So also change the key

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip6\Parameters

Also edit port 49330 to this key.

REBOOT the computer in order to test the actions

After the reboot the port 49330 is now connected to the Svchost.exe,

and my Service is started.

 

Special thanks to http://blog.brankovucinec.com/

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.