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...