Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Copy a database in sql 2008 R2

Answered Copy a database in sql 2008 R2

  • Wednesday, August 01, 2012 10:05 AM
     
     
    Sign In to Vote
    0

    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.

     

All Replies

  • Wednesday, August 01, 2012 10:59 AM
     
     
    Sign In to Vote
    0

    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
     
     Answered
    Sign In to Vote
    0

    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.