Transfer data across servers

[arst06d]

Hi

I need to transfer data across servers and have run into a problem which neither I nor my infrastructure chaps can explain.

I have used the Import DTS package wizard to create a new package, copying the data only from one server to the other. When I run the package I immediately get the error:

[SQL-DMO]CreateFile error on '[SourceServerName].[databasename].LOG'

My userid has been added as a local admin on the source server, and as system admin in both the source and target sql servers.

If I start a remote desktop session to the source server using mstsc -c then I can export the data to the target server no problem. I am not allowed to remotely log onto the target server.

So - if I am local amin on the source server how come I dont have "CreateFile" rights?

 

[Catadmin]

The problem might be what userID the DTS job is actually running under/as, which might not be the same userID as the owner of the package (you).

Also, does the SQL Server Agent service use a Domain User login or the Local System Account? SSA runs all jobs, so if it's using a Local System Account, it won't "reach" across the network to use the other server.

Just some random thoughts. HOpe they help.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.