SQL Server Service was unable to start

In SQL Server,I found the SQL Server Service stopped and it was unable to start.

SQL Service Stopped

Cause:

This problem might occur because of changing the service account password that wasn’t reset for SQL Server Service thence, it stopped.

Solution:

To check the state of SQL Server Service, follow the mentioned steps below:

  • Open SQL Server Configuration Manager:

SQL Server Configuration manager

  • Within SQL Server Services,Check the SQL Server Instance and SQL Server Agent state (Running/Stopped).
    • If it was running, try to restart it.
    • If it was stopped, try to start it.SQL Service Stopped
    • If it was failed to start >  Right Click on it > Properties > below Log on try to retype the user name and password then confirm it > Click Start.

Reset SQL Server AccountSQL service Starting

  • It should now been started.

SQL service Started

Enjoy 🙂

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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