Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Madhav
Starting Member
38 Posts |
 Posted - 2007-06-11 : 08:31:57
|
| Hi, when i am working on "copy database wizard" between two servers, i am getting an error message like....."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. "please solve this issue... |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-11 : 08:56:44
|
| Change your SQL Server Service account to be, for example, a Domain Account - i.e. that has access rights to the remote serverKristen |
 |
|
|
Madhav
Starting Member
38 Posts |
Posted - 2007-06-11 : 09:10:06
|
quote:
Originally posted by Kristen
Change your SQL Server Service account to be, for example, a Domain Account - i.e. that has access rights to the remote serverKristen
hi Kristen,I am not using remote servers. My servers are LAN connected.Can u please tell me how to give permissions to SQL Server Service account ? please help me....... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-11 : 10:32:34
|
| "My servers are LAN connected"Indeed. By "Remote" I mean "outside your first server". Linked Server can be another server on the same LAN, or across the Internet the other side of the world."Can u please tell me how to give permissions to SQL Server Service account ?"Same as you give permissions to any normal Domain User. You just grant the permissions to the "UserID" that the Service uses to log on.Your SQL Service is currently set to use the local system account, so that is "local" only. You need to change that to be a Domain User, or similar, [in Control Panel : Services] and then grant file access permissions to that user.I recommend that you create a new user specifically to be used, and to be only used, for/by the SQL Services.Kristen |
|
|
|
Madhav
Starting Member
38 Posts |
Posted - 2007-06-11 : 12:14:37
|
quote:
Originally posted by Kristen
"My servers are LAN connected"Indeed. By "Remote" I mean "outside your first server". Linked Server can be another server on the same LAN, or across the Internet the other side of the world."Can u please tell me how to give permissions to SQL Server Service account ?"Same as you give permissions to any normal Domain User. You just grant the permissions to the "UserID" that the Service uses to log on.Your SQL Service is currently set to use the local system account, so that is "local" only. You need to change that to be a Domain User, or similar, [in Control Panel : Services] and then grant file access permissions to that user.I recommend that you create a new user specifically to be used, and to be only used, for/by the SQL Services.Kristen
Thanx Kristen |
|
|
|
|
|
|
|
|
copy database wizard problem