RE: Copy Database Wizard Fails to Copy Files

I had the exact same problem until I executed the package under an account
that was explicitly defined in the sysadmin role, and not inheriting it.

Regards,

Don

"Robert" wrote:

> Running SQL Server 2000 SP3a on Win2000 Server (fully patched).
>
> Trying to get a simple example to work for copying a Test DB (which has one
> simple table) on ServerA to ServerB. DB does not exist on ServerB, both
> Servers running as services with identical accounts (made administrators; not
> Local System).
>
> Everything works fine in the DTS (using default options):
> Logins........Ok,
> Master.......Ok,
> MSDB.......Ok,
> Errors......Ok,
> <<CDW Database Tasks Fails...detailed steps below:>>
> Successfully created the share OMWWIZC........Ok
> Begin to copy the database Test...................Ok
> Database Test has no active connections.......Ok
> Put the database Test in single user mode.......Ok
> Try to detach the database Test..............Ok
> Successfully detached the database Test......Ok
> Failed to copy file \\ServerA\OMWWIZC\Program Files\Microsoft SQL
> Server\MSSQL\data\Test_Data.mdf.........Failed
> Successfully attached the database Test on source.......Ok
> Successfully deleted the share OMWWIZC.........Ok
> <<End of CDW trace>>
>
> Cannot get anything to transfer either from ServerA to ServerB or
> vice-versa. Constantly getting the same error (Failed to copy file.....)
>
> Help!?!
>
> Regards,
>
> Robert
>
>
>
.

Relevant Pages

  • RE: Copy Database Wizard Fails to Copy Files
    ... Regards. ... >> simple table) on ServerA to ServerB. ... >> Servers running as services with identical accounts (made administrators; ... >> Put the database Test in single user mode.......Ok ...
    (microsoft.public.sqlserver.dts)
  • RE: SQL Mail
    ... For SQL Mail to work, you need to have the service running under a domain ... Unless it is a domain account, ... > need to be able to send email via SQL from ServerB to ServerA. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Mail
    ... local account syncd with same password as domain account.. ... I have another mailbox on the domain XXX called pete.. ... > need to be able to send email via SQL from ServerB to ServerA. ...
    (microsoft.public.sqlserver.server)
  • Re: Domain Account used for IIS6 Anonymous Account Risks?
    ... In general there aren't any "known" vulnerabilities in Windows, IIS or probably your application that haven't been patched. ... but unless the vendor can explain why the application needs Administrator privileges, your answer should be that your security policy calls for least privilege, and the vendor should tell you what the actual privileges required of the application are. ... some of their own webpages) then IIS can connect to serverB using the ... domain\xyzweb account, and that account has full privileges on serverB ...
    (microsoft.public.inetserver.iis.security)
  • Re: Domain Account used for IIS6 Anonymous Account Risks?
    ... If someone can get IIS to execute arbitrary code (e.g. by uploading ... some of their own webpages) then IIS can connect to serverB using the ... domain\xyzweb account, and that account has full privileges on serverB ... Knowing all of this and knowing that as far as the application vendor, ...
    (microsoft.public.inetserver.iis.security)