Hi can anyone please help me....
when I run this query:
EXEC master..xp_cmdshell 'MKDIR \\Server02\FolderName'
it retuned me this error:
Logon failure: unknown user name or bad password.
if I run this command in command prompt in server01
It works fine...
Just in SQL returned error...
but if I use this instead:
EXEC master..xp_cmdshell 'MKDIR \\Server01\FolderName'
it also works fine.
It just server01 can't access any of my server using SQL but any of my server can access server01
Please help me. I been dealing with this for a week now.