Our Training Programs

All contents are copyright of their authors.

MSSQLSERVER service not start Error Code : 2

MSSQLSERVER service not start Error Code : 2

amit varma

10yAsked Feb 12, 2016, 9:16 AM1.1k

Hey guys,

i got problem while start ssms 2008,than i goro services and try to start the service (Sqlexpress) that time getting error

MSSQLSERVER service not start It displays the following error:

http://i.stack.imgur.com/oqQjw.png

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Chandu Kumawat10y ago
https://msdn.microsoft.com/en-IN/library/hh403394.aspx
amit varma10y ago
@Dear Shweta Lodha,

thanks for your valuable time.Till am not getting any solution. and the master and model database are not messing from their location.

All Database i see at "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA"

I am getting following error :

please see: https://goo.gl/ekdRaZ
Shweta Lodha10y ago
If possible, check your event viewer. Something might be logged there.
Shweta Lodha10y ago
Primary reason can be - your system database files(master and model) are deleted or moved to some other location. Other reason can be your service account password is changed. For more info, please check this:
https://community.embarcadero.com/article/articles-database/16041-top-3-reasons-why-my-sql-server-service-is-not-sarting