SQL Server Service account
-
I am trying to copy one database on one SQL Server to another SQl Server and I keep getting an error saying I need to change my SQL Server Service account to have the rights to copy files over the network. One of the servers is running under a local system account, but I am confused where I would change these rights. What am I forgetting to look at?
-
The problem is that the local service account does not have rights on the remote machine. Assuming that you have not removed the Builtin\Administrators account from either server, if you open EM using an account with administrative privileges, it should work that way.
Better option:
If you just want a copy of the database on the other server, take a full backup, copy the resulting *.bak file over to the second server. Then you'll need to create a new database (sizing it appropriately) and select Restore. Use the 'From Device' option and browse to the file that you just copied over. Make sure you check the 'Force Restore over Existing Database' box on the options tab. You should then be good to go.
My hovercraft is full of eels.
-
Local system account has no rights on the network. It is by design. In EM right click on your SQL Server, go to properties, Security and change the account under which the service runs to an account that is either a domain account or the same account as on the other server that has rights to the specified directory.
=================
Theory without practice is dead. Practice without theory is blind. (A. Zarusskiy)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply