Hi,
I have two Windows 2000 Servers. The first one is the domain controller with SQL 2000 installed (Production Box). I just installed a second Windows 2000 Server with SQL 2000 as well. I joined the domain as an additional domain controller. I want to use the copy database wizard to copy over my database from server 1. Basically I am trying to replace server 1 with server 2 (faster box). When I try to copy the database, it says "Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network." I have Active Directory installed and I find the user policies but I don't see any that specify coping files across the network. Also which server would this policy reside on?
Thanks In Advance!
Jenica
I have two Windows 2000 Servers. The first one is the domain controller with SQL 2000 installed (Production Box). I just installed a second Windows 2000 Server with SQL 2000 as well. I joined the domain as an additional domain controller. I want to use the copy database wizard to copy over my database from server 1. Basically I am trying to replace server 1 with server 2 (faster box). When I try to copy the database, it says "Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network." I have Active Directory installed and I find the user policies but I don't see any that specify coping files across the network. Also which server would this policy reside on?
Thanks In Advance!
Jenica