on 11-22-2010 1:25 PM
Hello,
I have problem with executing a full backup:
The job failed. Unable to determine if the owner (host1\SAPServiceDEV) of job SAP CCMS Full DB Backup of DEV,master,msdb [20101122133632] has server access (reason: Could not obtain information about Windows NT group/user 'host1\SAPServiceDEV', error code 0xffff0002. [SQLSTATE 42000] (Error 15404)).
This user exist and isn't blocked.
There is a free space on backup disk. Permission for everyone to this disk i set temporarly but no effect.
Any ideas?
Best regards,
Michal Sarna
Michael,
Thanks for updating the post with solution - I had the exact same error and your solution was quite useful. Note that I changed the logon for both the "SQL Server (MSSQLSERVER)" and "SQL Server Agent (MSSQLSERVER)" services to get it to work.
Regards,
Jason
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Solved on my own.
I change OS user which is owner of SQLAgent service to SAPServiceSID.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
System log viewer may have more information about this error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.