Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    6

    Unanswered: Error during Copy Database Wizard operation

    Do anyone know why i got "Failed to create the share OMWWIZD" error message when trying to copy databases from SQL Server 7.0 to SQL Server 2000?

    Thanks!

  2. #2
    Join Date
    Apr 2002
    Posts
    20

    Re: Error during Copy Database Wizard operation

    Probably something to do with security permissions between the two servers. If so, pick an administrative account which is the same on both. Run the wizard as that account. Test access by logging into one server and map a drive to the other.


    --jfp

  3. #3
    Join Date
    Mar 2003
    Posts
    6

    Re: Error during Copy Database Wizard operation

    Thanks for the suggestion! I tried using a domain admin to copy the database over and it works! I was using a local admin account before to establish the connection.

    Thanks again.

    --Speedster.

  4. #4
    Join Date
    Dec 2005
    Posts
    1

    Red face

    hi

    I have the same problem but i'm in workstation ...
    i used Administrator account in the source server and the destination server, but it doesn't work

    What can i do ?

  5. #5
    Join Date
    Sep 2005
    Posts
    2

    Cool

    - quoting "hi I have the same problem but i'm in workstation ...
    i used Administrator account in the source server and the destination server, but it doesn't work What can i do ?"


    asanhaji, are you accessing it from a windows workstation via Enterprise Manger? Is it possible to be at one of the servers locally and try to copy it over? Unless you are a logged into the workstation with a domain admin account OR connect to the server in Enterprise manager with a domain admin account you may not have any luck in copying the stuff over. You may need to connect to both servers using a DBO account (typically sa is the user name for it).

    slashman

Posting Permissions

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