• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 978
  • Last Modified:

I get an error "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 get an error "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.  This occurs when I try and right click on the databases folder in Enterprise Manager and then go through the Copy Databases Wizard.  I can copy each database individually though.

I looked at the Services and properties of MSSQLSERVER and it has local system checked (this is the same as my local machine and production server).  I'm not sure what to do so that I can import databases from my production machine to my staging server.  I'm just setting up a new staging server...

Thanks!
0
Ike23
Asked:
Ike23
2 Solutions
 
Anthony PerkinsCommented:
The local system account does not have access to the network resources.  You need to:
A. Change the SQL Server service startup account to a domain account.  
B. Copy the files using a domain account to the SQL Server, before running the Wizard.
0
 
imran_fastCommented:
Hi,
You have to change sql server servie to run under domain admin account. or as Acperkins suggested to do that.

To change SQL Server services login account information (Windows 2000)
On the Start menu, point to Programs/Administrative Tools, and then click Services.
Right-click MSSQLServer, and then click Properties.
On the Log On tab, enter and confirm the new password, and then restart services using the SQL Server Service Manager.
Repeat the password reset for SQLServerAgent and other services.

better restart the services after that.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now