Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Having backup problems, and unable to change service accounts... Expand / Collapse
Author
Message
Posted Saturday, May 25, 2013 2:02 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:51 PM
Points: 904, Visits: 4,450
Two problems, possibly related, both giving me heartburn as I'm going away for 2 weeks and don't want to leave a server in this state...

Problem 1:
When I try to run a backup to anywhere *EXCEPT* the default SQL backup folder (\program files\microsoft sql server\mssql10_50.mssqlserver\mssql\backup\) fails with a system error 5 (Access denied.) Now, the SQL Server service account is a member of the local Administrators group, and I've checked the permissions and there's nothing that should be blocking it.

Problem 2:
When I try to change the service account to any other account, I get a "wmi provider error - Access denied - 0x80070005" message. All the solutions I've seen for this say "click on the browse then key in the account name and "check name" and re-enter the password." Well, no dice, same error. Even if I try to use one of the local system accounts, same error.

I'm logging into the server with a local Administrator account, so I have the rights to do this stuff. It was all working before I installed some Windows updates, since then it's gone pear-shaped. I've tried uninstalling the updates, that hasn't helped. I've got 2 other SQL Servers, identical configurations (same OS version, same SQL version, heck everything is installed to the same places!) which are NOT having this problem.

I've been Googling this problem most of today, and it's PISSING ME OFF!
(sorry about that)

Any help, any suggestions will be deeply appreciated.

Thank you,
Jason
Post #1456811
Posted Saturday, May 25, 2013 2:12 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:51 PM
Points: 904, Visits: 4,450
Couple more things, about the same server:

I'm unable to create a new database (also throws an access denied)

OS: Server 2008 SP2
SQL: SQL Server 2008 R2 SP1
Post #1456812
Posted Saturday, May 25, 2013 4:13 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 9:55 AM
Points: 684, Visits: 1,345
What permissions does the SQL Server (not the agent) service account have on the server?

Joie Andrew
"Since 1982"
Post #1456821
Posted Sunday, May 26, 2013 4:46 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:51 PM
Points: 904, Visits: 4,450
the SQL Server service account is a member of the local Administrators group
Post #1456929
Posted Sunday, May 26, 2013 9:16 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:40 PM
Points: 1,077, Visits: 1,496
Run SQL Server Configuration Manager as Administrator (right click) and try again. What error is in the Windows Application log? What error in SQL log? What are the permission differences on the SQL folder, including the folder Ownership.
Post #1456956
Posted Monday, May 27, 2013 7:40 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:51 PM
Points: 904, Visits: 4,450
foxxo (5/26/2013)
Run SQL Server Configuration Manager as Administrator (right click) and try again.


Tried that early on, made no difference...


foxxo (5/26/2013)
What error is in the Windows Application log? What error in SQL log?


When trying to change the service account, no error is recorded in either the Windows or SQL logs...
When trying to run a backup (via T-SQL, not an Agent job) only the "Access denied" message.


foxxo (5/26/2013)
What are the permission differences on the SQL folder, including the folder Ownership.


I've looked at the permissions until my eyes have bled, no differences. Ditto ownership.
Post #1457104
Posted Monday, May 27, 2013 7:16 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:40 PM
Points: 1,077, Visits: 1,496
Im wondering if some permissions were stuffed somehow after the Windows updates.
You need to narrow down the cause for the Access Is Denied WMI event. You can turn on a WMI trace in Windows event viewer, instructions here http://msdn.microsoft.com/en-us/library/windows/desktop/aa826686%28v=vs.85%29.aspx
Then try changing the service account again, there should be an event in the log, look for any errors.
Post #1457165
Posted Tuesday, May 28, 2013 7:48 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:51 PM
Points: 904, Visits: 4,450
Foxxco, thanks for the idea...

Now if only the guys I work with would text me back, so I could point them to your suggestion...
Kind of hard to work from an airport, especially when I don't have (and didn't bring) my work laptop.

Jason
Post #1457322
Posted Wednesday, June 12, 2013 6:38 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:51 PM
Points: 904, Visits: 4,450
I'm thinking permissions are beyond stuffed at this point...

I tried Foxxcos' idea, and there are NO errors / warnings / critical events logged in the WMI log when I try to change one of the service accounts. Lots of other stuff gets logged, but I've not yet taken the time to try to plow through and see if I can find my attempt at changing the service account.

As of now, last night we tried loading an OS update MS support suggested, as well as (the expected long shot) running chkdsk /f on the drives. Unfortunately, we're still in the same boat.

Also come to find out, this problem has managed to also break Full Text Indexing on the one DB using it, and Filestream on the DB using that...

Getting psyched up to start a "crash" migration to a new server, although I'd really rather avoid that right now (in the midst of a migration already from a Server 2003 / SQL 2005 Cluster to a new Server 2008 R2 / SQL 2008 R2)

Thanks,
Jason
Post #1462593
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse