January 10, 2011 at 9:25 am
I'm posting this in case it keeps someone else from losing hair. SQL Server 2005 Enterprise.
I was implementing the MS-recommended best practice of creating a domain user account to run the SQL Server DB service. When configuration manager tried to re-start the service, I got the above error (sql service "access is denied" wmi provider error 0x80070005) and the service failed to start.
The only useful info. I could find on this frustratingly obscure error message was found.... here! 🙂 Here is the solution that worked for me. Specifically, I needed to add that domain account to the server's local users group. I'm pretty sure that the Domain Users group had been added to the server's local users group automatically when the server was first set up, but I had removed it because Domain Users had no business accessing the server. So my new domain account couldn't access the server and couldn't start the SQL service.
This was particularly frustrating to me for 2 reasons: (1) the configuration manager supposedly auto-magically sets all required permissions, but it doesn't and (2) the popup error lacks sufficient detail to find and fix the problem.
So, maybe someone else will find this useful!
Rich
January 10, 2011 at 11:06 am
Thanks for sharing!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply