I am using Copy Database wizard to copy a database (DB Name: BROKEESC) from SQL Server 2000 to 2005.
Both the server's are running on (Windows Server 2003, SP1).
BROKEESC is 4GB database. It have around 350 user tables, 2000 stored procedures and all other objects exists in it.
I have sa user with me on both source and destination server.
I am trying with detach and attach method.
In Copy database wizard, on "Location of Source Batabase Files" page
In File share on Source Server textbox, i gave data file path on source server. (i.e. \\SOURCEDB\C$\Program Files\Microsoft SQL Server\MSSQL\Data)
But it gives me Error while executing package. Error says that. "Access to the path '\\SOURCEDB\C$\Program Files\Microsoft SQL Server\MSSQL\Data\ctyis_before_migrate_data.mdf' is denied.'
As sa is database user, i am not able to give access to sa user on above denied path.
I tried with one of windows authentication user, which is sys admin o db server. But Copy database wizard is not able to connect to source db.
I am on task to copy db from SQL Server 2000 to 2005 and make it in working condition.
Please let me know, How can i move ahead using Copy database wizard?
Thanks in advance,