Have attempted a number of things to get this service (SQL Server (MSSQLSERVER)) started without any luck

  • Attempted to start service with local admin, domain admin, separate admin & standard accounts
  • Attempted to change logon account for the service.
  • Could not see any anomaly in Process Monitor
  • SQLcmd throws an access denied, despite having full domain admin and local admin group AND EVERYONE as full control. SYSTEM by default has full control.
  • Attempted to 'repair' the SQL instance, throws up this error several times:

Attempted to perform an unauthorized operation

The error i get when attempting to start the service:

The SQL Server (MSSQLSERVER) service failed to start due to the following error: Access is denied

The SQL Server Reporting Services (MSSQLSERVER) service failed to start due to the following error: Access is denied

There are no other error codes. All SQL services except the SQL Server Browser and SQL Server VSS Writer is dependent on MSSQLSERVER starting up correctly.

Running SQL Server 2012 SP1 CU2 on Window Server 2012. Service was fully working before a reboot, no Window Updates has been applied.

So anything else i could try?

  • the reporting service is not the same as the sql service, so I think that the sql process must be starting up the reporting process. I have not play with sql servers in a long time so I could be way off. – tony roth Jun 14 '13 at 15:47
  • ahh apologies, this is affecting all SQL Services including reporting services. – Cold T Jun 14 '13 at 15:48
  • start it up as local system temporarily, does that work? – tony roth Jun 14 '13 at 16:42
  • 2
    @ColdT, the link I referenced is how to start SQL Server in single user mode. That should not run SQLCmd, but sql server directly. See msdn.microsoft.com/en-us/library/ms180965(v=sql.105).aspx for a clearer explanation. Does the server start correctly? If not, it should print an error from SQLSERVR.EXE which would be helpful. – Mitch Jun 14 '13 at 18:45
  • 1
    Check the log, find out which file, FIX IT. – TomTom Jun 14 '13 at 18:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.