December 2, 2009 at 3:36 am
Hi ,
i'm facing the strange problem. From few weeks i'm getting my backup job fails when i check from the query window it is giving following error:
Cannot open backup device '\\DOMAINSYSTEM\SERVERBKPS\DBBKP22009206PM.BKP'. Operating system error 1396(Logon Failure: The target account name is incorrect.).
but i'm able to open that network path folder and also able create a file from my system. what is wrong with the system.
🙂
December 2, 2009 at 3:53 am
try to open share folder from the server where SQL Server is installed with login id which used to start the services of SQL Server hope this might help you.
December 2, 2009 at 4:18 am
hi,
your right, it's not opening the network path. what i need to do for this issue?
🙂
December 2, 2009 at 4:39 am
give rights read and write to the share folder in the domain for the login id of the server and then try. you also consult your sysadmin for this
December 2, 2009 at 6:14 am
Whatever context SQL Server is running under, it does not have access to that network share. Even if you do, and you're running the command, it doesn't matter, the SQL Server security context is what will have to be able to write to that network share.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply