Discussion Locked

SQL 2000 DTS problem "copying file"error

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In running the DTS to copy a database from a SQL 7 server(running under NT 4.0) to a SQL 2000 server (running Win2K), using a domain login account (admin account, which is also the startup account for SQL on both servers)I get a success on the logins, the creating of the share point, the detach of the database, the putting database into single user mode, but then a failure (after approx. 90 seconds) on the file copy step. It then successfully reattaches and delets the share point. The error code is listed as a permissions problem, but being the admin on both machines, as well as having the admin in the sysadmins role on both SQL servers, I am at a loss to figure out what is happening here....

2 replies

by jurasek

Check the SQL Agent service login. Make sure it is also a local Admin domain account.

by dlanors

What do you mean by a "Local" admin domain account?? (I have made the password for the local admin the same as the domain admin.)

This discussion is closed to new replies.