Copy Database Wizard

Using SQL 2000 SP3a on Windows 2000 Server, Active Directory domain. I want
to copy a database from a development server to a production server. But
when I run the Copy Database Wizard, it says the SQL server Service can't
run under the local system account. I've searched MSDN and couldn't find
anything on this subject. Do I need to enable the Interact with the Desktop
option? Or do I need to create a Domain User for both servers to run under?
Or local users on each machine with some extra priveleges?Have a look at the "Permissions to Copy the Files" section in
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ron Hinds" <__NoSpam@.__NoSpamramac.com> wrote in message
news:e8hQmUurDHA.3748@.TK2MSFTNGP11.phx.gbl...
Using SQL 2000 SP3a on Windows 2000 Server, Active Directory domain. I want
to copy a database from a development server to a production server. But
when I run the Copy Database Wizard, it says the SQL server Service can't
run under the local system account. I've searched MSDN and couldn't find
anything on this subject. Do I need to enable the Interact with the Desktop
option? Or do I need to create a Domain User for both servers to run under?
Or local users on each machine with some extra priveleges?