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

Odd permissions issue when backing up to a network location Expand / Collapse
Author
Message
Posted Thursday, July 11, 2013 2:33 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 6:07 AM
Points: 50, Visits: 451
I have a 2005 box and 3 2008 boxes. All 2008 boxes backup fine to the network location however, I'm getting a 'Cannot open backup devices '\\server\drive'. Operating system error 5(Access is denied). ' error. I'm using the same account on all 4 servers with full control over the directory. Logged into the 2005 machine I can open up the network location and create files. Any ideas?

*Edit - The service account also has full control over this directory.
Post #1472778
Posted Friday, July 12, 2013 7:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Is that 2005 box using an alias user to take backup?

Regards
Durai Nagarajan
Post #1473041
Posted Friday, July 12, 2013 8:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:24 PM
Points: 5,318, Visits: 9,760
Is your backup running as a job? Does the SQL Server Agent account have access to the target folder?

John
Post #1473049
Posted Friday, July 12, 2013 8:18 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 6:07 AM
Points: 50, Visits: 451
Thanks for the replies.

The agent account is the same as the service account, so it has full control over the directory. Can't execute as a job or in a query window.

No alias. I can't write write using my own login, I can write backups from the other three. The other three are windows/sql server 2008 while this is windows 2003/sql 2005 for what its worth.
Post #1473061
Posted Friday, July 12, 2013 11:38 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 7:27 PM
Points: 33,204, Visits: 15,351
I would start to suspect timing (check computer times) or some other Kerberos/SPN issue from this machine to others.

I might try changing the service account, restarting, then changing it back and restarting. I've seen weird issues like this in the past (SQL2K). Haven't heard of it in some time, but otherwise you might need to log in as the service account and do some troubleshooting from this, and another, machine.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1473169
Posted Monday, July 15, 2013 11:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 6:07 AM
Points: 50, Visits: 451
We have this resolved. It was an NTFS/sharing confilct. Thanks
Post #1473820
Posted Monday, July 15, 2013 1:11 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 7:27 PM
Points: 33,204, Visits: 15,351
thanks for the update. Any resolution steps others could try?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1473862
Posted Tuesday, July 16, 2013 12:17 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 6:07 AM
Points: 50, Visits: 451
I don't have the exact steps to solve as a coworker found the issue. I'm guessing whoever initially set up access did not allocate the proper access at both levels, resulting in the least restrictive permission being enforced.

Post #1474250
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse