cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL2005 failed to execute full backup

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

Solved on my own.

I change OS user which is owner of SQLAgent service to SAPServiceSID.

Former Member
0 Kudos

System log viewer may have more information about this error.