I am trying to copy a database from a remote server to a local server using
the copy wizard (DTS). Everything seems to go OK until the last step at
which time I get the below error. I have not had a lot of success in my
searches. The log detail says

Failed to create the share OMWWIZC as part of the databases task step. The
error code is -2147467259.

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

Can anyone tell me where to find what this means and how to fix it. The
service on the destination is running on an account that has administrative
rights (not local service). SQL 2000 on a Windows 2003 server.

Hello MikeV06,

There is a KB article for this task here

http://support.microsoft.com/default...NoWebContent=1

which also features your error.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

On Thu, 6 Apr 2006 20:02:53 -0500, MikeV06 wrote:

An update. From my search, supposedly this error occurs because the server
is running under local system rather than on an administrative account.
However, I still get it when I run the service via an administrative
account. I can import from the remote database. Does the copy wizard have a
problem?

Thanks.

On Sun, 09 Apr 2006 13:39:31 -0700, Allan Mitchell wrote:

Thanks. I had read that article a couple of times, but went back one more
time:

"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: ..."

Uhm, this says my local laptop SQL Professional instance which is running
under a local account which has admin rights on the laptop (into which I am
trying to copy the database) must also have local admin privileges on the
Win 2003 SQL Server system. No wonder it is not working.

Yes, I understand that it is recommended that one use Windows
authentication, but I have reasons that prevent that from being an option.

I want to have a workstation/laptop which is running SQL Server 2000
Professional to be able to connect to a remote (using WAN, not LAN) SQL
Server 2000 and copy a database (using SQL authentication). Obviously, the
copy wizard is not the correct tool.

Interestingly enough though, it appears that import data works under the
exact same circumstance.

Thanks for the response, I will stop trying to use copy wizard for this
task.