March 6, 2015 at 12:22 pm
Hello all:
Our DBA is away taking care of business and I have been tasked to move a DB from SS2005 to SS2012. The very fact that we are having this conversation should tell you how it’s going.
The source server runs 2005. I have SA rights on that server if I log in using the SS login ‘sa’ + pw.
The destination server runs 2012 and one of my Windows accounts (su – super user) has been mapped to sa. Because I don’t normally run my local workstation under the su account I elevate and run SSMS under my su account for this operation.
So I am connected to source 2005 as sa + pw.
I am connected to destination 2012 as Windows su.
I attempt to Copy Database on the 2005 box. The wizard gets me almost to the end but it all terminates with error: “While trying to find a folder on SQL and OLE DB error was encountered with error code 0x80040E4D (Login failed for use ‘sa’).”
The error doesn’t specifically tell me on which server the login failed here, but my assumption is it is failing on source 2005 as that is where I am logged in directly as sa, and not mapped to a Windows login. Is this a sound assumption?
And I can only guess that it is the data folder that SS is having issues accessing. I have tried both copy methods (SS Object, and Detach), and both fail with this error, though only the detach method asks for a shared folder path.
The directions on the Location of Source database Files step of the wizard says “To move or copy the database using the detach and attach method, the Copy database Wizard requires access to the source database”
I have experimented with different folder paths:
\\[SERVER]\D$
\\[SERVER]\D$\data
\\[SERVER]\D$\Program Files\Microsoft SQL Server\MSSQL.90\MSSQL\Data\
\\[SERVER]\C$\Program Files\Microsoft SQL Server\MSSQL.90\MSSQL\Data\
… with no luck. I do not have access to the source 2005 server OS to verify these paths.
Can anyone see the glaring hole? Thanks.
March 6, 2015 at 1:53 pm
Try using backup and restore.
March 6, 2015 at 2:17 pm
Ha! Thanks. Our DBA called and said exactly that. Now I am working through file permissions between our destination server and file share. I guess I'm getting closer.
Thanks.
March 9, 2015 at 6:25 am
Hi,
Please do not forget to select right compatibility mode as you are restoring database from SQL2005 to Higher version, else could pain you in future.
March 9, 2015 at 7:59 am
Check the Database consistency; If it is ok then Doing a Backup and Restore is the perfect option and then change the compatibility to 110.
March 9, 2015 at 9:45 am
Thanks folks. I will give this another go once my IT folks fix my permissions issues to the share drives.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply