Post reply

Permissions issue with Copy database wizard.

  • August 11, 2008 at 1:19 am

    #122851

    Hi,

    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,

    Sachin.

  • July 4, 2011 at 6:53 am

    #1347814

    Having similiar problem. Did you make any progress?

    Thanks

    J

  • June 26, 2013 at 10:55 am

    #1627657

    Make that three of us. Every time I run the Copy wizard, it either throws a permission error like yours or just hangs completely.

    Sigerson

    "No pressure, no diamonds." - Thomas Carlyle

  • June 27, 2013 at 2:21 am

    #1627842

    Long time ago now and can't remember what solved it!

    Make sure that your SQL Server Agent account has access to the drive the backup is held on. Try this.

  • June 27, 2013 at 7:39 am

    #1627969

    Thanks for the response. Yes it was a permissions issue so I ended up using backup and restore d/b which worked fine. Calling that Copy Database a 'wizard' is a little short of the mark, it should be more friendly and informational, or else a message to warn off casual users.

    Sigerson

    "No pressure, no diamonds." - Thomas Carlyle

  • June 27, 2013 at 8:25 am

    #1627998

    Never met a real wizard yet

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply