troubleshooting Question

Error 0x80040E4D when copying database from 2005 to 2008

Avatar of Rouchie
RouchieFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL Server 2008
40 Comments4 Solutions5295 ViewsLast Modified:
I have recently upgraded my development machine from SQL Server 2005 to SQL Server 2008.  When I use the Copy Database wizard to copy our online database to the dev machine, I get the following error as soon as the copy process begins:

While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80040E4D (Login failed for user 'sa'.).

I am only connecting to the remote (2005) machine using 'sa'.  My local connection (SQL 2008) uses Windows Authentication.  I know the password used for 'sa' is correct because I connect to the server via Management Studio using the same password.

The process has always worked perfectly when copying between 2005 servers.  Can anyone help with this?  I'm wondering whether I've done something wrong during installation...
ASKER CERTIFIED SOLUTION
Mark Wills
Topic Advisor
Join our community to see this answer!
Unlock 4 Answers and 40 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 40 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros