Could someone help us with a problem we're having with regard to
moving several databases from SQL 7 to SQL 2000 on different servers
in different domains. Our current SQL 7 server resides in one domain,
and holds several databases. We now want to move these to a SQL 2000
server in another domain.
We're trying to use the Copy Database wizard on the SQL 2000 server
(logged in as the local admin account), selecting the SQL 7 server as
the source, using 'sa' account on that server. The target is the SQL
2000 server, again using 'sa' account. We're leaving everything else
with regards to logins, jobs etc as default (i.e. taking everything
that can be found), but when the steps execute, the last step that
brings the database across fails with an error code -2147467259 -
Failed to create the share OMWWIZI.
Can anyone help us out with this error, or provide any suggestions as
to what we can do?
Any help would be greatly appreciated. Thanks.