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

    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.

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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.

    -PatP
    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
  •