Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
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
    
What happens when you try it interactively? msdn.microsoft.com/en-us/library/ms188236.aspx –  Mitch Jun 14 '13 at 18:04
1  
Check the log, find out which file, FIX IT. –  TomTom Jun 14 '13 at 18:45
show 3 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.