Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Question Unanswered: copy wizard gives error creating share

    When I run the database copy wizard I'm getting an error creating shared omwwize.

    The source server is 7.0. The destination server is 2000. I'm invoking the wizard from the 2000 machine.

    Anybody know what this error means?


  2. #2
    Join Date
    May 2004

    Smile found my own answer

    If the destination SQL Server is started under a domain account that does not have local administrator privileges on the source computer then the following error message may be generated by the wizard:

    Step Error Source: Microsoft Data Transformation Services (DTS) Package
    Step Error Description:Unspecified error

    Step Error code: 80004005
    Step Error Help File:sqldts80.hlp
    Step Error Help Context ID:1100
    Clicking on the "MORE INFO >>>" button, you will find that permissions to create the remote share are not present.

    Failed to create the share OMWWIZD

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts