Very Computer

by **Antoine GOLI** » Wed, 05 Mar 2003 20:05:23

1 SQL2K Ent. (server A source) (domain A active directory)
1 SQL2K Ent. (server B destination, monitor) (domain B active directory)

When initialising Log Shipping , the 2nd step fails (initializing
destination...) with the following error msg : "unable to copy the
initialization file to the secondary server'server2'".

Permissions of the share on the source server are Everyone Full Control.

I think about security problem during the copy of the files.
SQL server agent (server A) is using a domain A account.
SQL server agent (server B) is using a domain B account.

by **John Bandettin** » Thu, 06 Mar 2003 01:02:13

Antoine

If you are running SQL Agent as a local account, make sure
it is the same name and password. Then it should work.

Regards

John

Very Computer

SQL2K - Log Shipping - 2 # domains

SQL2K - Log Shipping - 2 # domains

SQL2K - Log Shipping - 2 # domains