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!

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