Sunday, March 25, 2012

COPY DB

I'm trying to copy a database using the copy db wizard. The source and
destination are both sql 2000. I'm getting the following error message.
CDW Database task Step Fails
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
TASK DETAIL
FAILED TO CREATE THE SHARE OMWWIZC
The SQL Admin account has to have permissions to access teh file system on
the other machine, not just the other SQL Server.
Robert.
"sql" wrote:

> I'm trying to copy a database using the copy db wizard. The source and
> destination are both sql 2000. I'm getting the following error message.
> CDW Database task Step Fails
> 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
>
> TASK DETAIL
> FAILED TO CREATE THE SHARE OMWWIZC

No comments:

Post a Comment