xp_cmdshell - Access Problem

[SQLBI]

Hi,

I'm trying to execute the following xp_cmdshell statement in order to create a new directory on a different machine to my SQL server.

xp_cmdshell 'mkdir "\\Prnsrv01\reminders and direct mailing\Test Dir"'

When i try to create the file locally, all is well, however not on the remote PC.

I have ensured that my "DOMAIN\SQLService" account has access to the shared resource on the remote PC and that it has local admin access too, but still no joy.

Can anyone suggest where i'm gong wrong?

Cheers,
Leigh

The problem with common sense is that it isn't that common!

 

[mrdenny]

The network share permissions?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBI]

Typical... I added my SQLService user on the security tab of the share and not in the permissions on the Sharing tab.

Thanks mrdenny.

Cheers,
Leigh

The problem with common sense is that it isn't that common!

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com