Cannot Copy SQL Server Database Due To "Unable to determine if the owner X of job Y has server access"



TODO:

Have you tried to copy a database in SQL Server Management Studio, and receive the following error "SQL Server Scheduled Job 'CDW_X_X2008_X_X2008_5_4' (0x623E46E604C04B4EB2BA2310660B1E3D) - Status: Failed - Invoked on: 2012-07-12 10:20:47 - Message: The job failed.  Unable to determine if the owner (X\Administrator) of job CDW_X_X2008_X_X2008_5_4 has server access (reason: Could not obtain information about Windows NT group/user 'X\Administrator', error code 0x534. [SQLSTATE 42000] (Error 15404))."

 

SOLUTION:

In my case, the DB owner, was associated with the Administrator account of my old server.  I had replaced it with a new server and moved all of the databases over to the new machine.  I simply went to "Logins" under "Security", and renamed the old user to the new user,  executed sp_changedbowner 'newowner' (use sp_helplogins to get list), and lastly went back and re-ran the copy job, and all worked as expected.

 

NOTES:

There are no notes on this topic.