xp_create_subdir on Remote server

[SQLScholar]

Hey all,

I am looking to standardise our backups across the domain - and back everything up to a central server.

Part of the script issues a xp_create_subdir() to a remote directory.

On one server it suceeds and another it fails. Both have been run on SQL server with the same login (domain login) and both have the same user set up to run Agent and SQLserver.

What else could be stopping it?

Dan

----------------------------------------

http://www.cardboardcoder.com

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[djj55]

Hello,
What version of SQL?
Is there an error message?

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[SQLScholar]

Sorry SQL 2005 Standard SP3

Msg 22048, Level 16, State 1, Line 0
xp_create_subdir() returned error 5, 'Access is denied.'


----------------------------------------

http://www.cardboardcoder.com

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[SQLScholar]

and sorry - it was me being dumb. Fixed it - i thought it was the same account, but it was nearly the same account (one letter difference) DOH!

Sorry

----------------------------------------

http://www.cardboardcoder.com

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------