Wednesday, August 01, 2012 10:05 AM
While copying the database using copy database wizard from one instance of sql to another, I am getting the following error
The owner of job ....does not have server access.
Can you please let me know if I am missing anything.
Wednesday, August 01, 2012 10:59 AM
Your current job owner is not having access on server.
Goto properties of Job > Check Job Owner - User > Provide access to Job Owner - User on Server
Check & share Copy database wizard error that you may save in windows event log or test file for more error details.
Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!
Wednesday, August 01, 2012 12:17 PM
Make sure that the credential you are using for the copy database wizard is having SYSADMIN privilege on both source and the destination server. I think fixing this should solve your problem.. Also provide local admin privilege to that user on both the servers to make sure that you are able to copy files to the respective folders -- this is needed when you are using attach and dettach option.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Thursday, August 30, 2012 1:48 PM