Re: [NTISP] Database transfer task
Dale E. Reed Jr. ( (no email) )
Fri, 11 Feb 2000 09:40:57 -0800
Adam Greene wrote:
> I've been trying to schedule a database transfer from one SQL server to another
> using SQL Enterprise Manager. It never works when I schedule it. I get the
> message, "cannot connect to destination server." However, if I run the transfer
> manually, it does work. Also, if I run it from the command line (XFRAGENT -i
> "server" "database" "id") it works, but if I try to schedule it using AT, it
> doesn't. It's as if AT doesn't process command parameters.
> Does anyone know how to schedule a transfer successfully?
First, use SQL Agent or SQL Executive to schedule it. Then make sure
that th Agent/Executive service is running as someone who has
to access the other SQL Server. By default they run as the local
SYSTEM account, which doesn't have network access. Check your
protocols as well.
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart