Thread: Copy Wizard utility
01-23-12, 16:44 #1Registered User
- Join Date
- Aug 2007
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.
01-23-12, 17:53 #2Resident Curmudgeon
Provided Answers: 54
- Join Date
- Feb 2004
- In front of the computer
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.
-PatPIn theory, theory and practice are identical. In practice, theory and practice are unrelated.