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 ««123»»

Running a sql server 2008 job to back up to network folder Expand / Collapse
Author
Message
Posted Monday, April 4, 2011 3:02 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Wednesday, October 22, 2014 12:34 PM
Points: 31,181, Visits: 15,626
It's definitely permissions. AFAIK, however, it's the SQL Service account, not the agent account, that needs permissions.

The agent logs in just like you do from your workstation. The backup is run by the SQL engine, and it's service account needs permission.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1088303
Posted Monday, April 4, 2011 3:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 8:37 AM
Points: 5, Visits: 44
SQL Server Services and the agent runs under same account.

Thanks!
Post #1088307
Posted Monday, April 4, 2011 3:18 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:18 PM
Points: 17,824, Visits: 15,756
The network share - is it by chance a DFS replicated share?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1088311
Posted Monday, April 4, 2011 4:10 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Wednesday, October 22, 2014 12:34 PM
Points: 31,181, Visits: 15,626
It is permissions. OS 5 is access denied from Windows.

there has to be something weird going on there. Can you run this on your system and perhaps see permissions and verify?

http://technet.microsoft.com/en-us/sysinternals/bb897332

Can you do a "dir > n:\test.txt" in a job with the same credentials?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1088330
Posted Tuesday, April 5, 2011 3:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 8:37 AM
Points: 5, Visits: 44
it is CIFS.
Post #1088943
Posted Wednesday, April 6, 2011 12:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:15 AM
Points: 129, Visits: 2,441
Not sure if this will help but I once ran itno something similar.
I changed the server name to it's ip address and the unc and is started working.



Post #1089484
Posted Wednesday, April 6, 2011 2:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 8:37 AM
Points: 5, Visits: 44
Steve,
When i ran accessenum on the box, it did show me that the user i am logged in has read and write access to the shared folder.
Post #1089598
Posted Thursday, April 7, 2011 12:22 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Wednesday, October 22, 2014 12:34 PM
Points: 31,181, Visits: 15,626
Can you run the "dir" job from Agent and have that work?

It's definitely a strange error. It's almost like you have some token or kereberos issue with the job.

If you manually run the backup, does that work?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1090143
Posted Thursday, April 7, 2011 12:51 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:18 PM
Points: 17,824, Visits: 15,756
Have you tried relaxing the permissions for the share?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1090172
Posted Thursday, April 7, 2011 12:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 11:42 AM
Points: 20, Visits: 64
Capture a Process Monitor trace on the destination server and check if the account requesting access on the share is showing up as anonymous. It could be an impersonation issue.

This posting is provided "AS IS" with no warranties, and confers no rights.
My Blog: TroubleshootingSQL
Twitter: @banerjeeamit
Post #1090174
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse