Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007

    Question Unanswered: Copy Wizard utility

    I am attempting to use the copy wizard to copy databases from SQL Server 2005 to SQL Server 2008 R2 w/ FP1.

    The copy fails with a login failure to SQL Server 2005. I have a user id & password under Windows for both servers. I have a user id and password under SQL security with the called for admin security rights.

    Does anyone have an idea as to why I am receiving a login error?

    The 2005 server has two instances, 20 databases, two dozen maintenance plans, and over a hundred users. I really would like to use the utility so I don't have to recreate everything manually.


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    When SQL utilities fail to log in to a SQL instance, the utility should display an error message. The display ought to contain both a number and some text. Read the text, it will almost certainly describe the problem that is preventing the utility from accessing your SQL Server.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts