April 24, 2003 at 8:59 am
I am trying to use CDW to move logins from SQL Server 7 to 2000. The only pre-requiste that I know off, is that I have to be a system admin on both the source and destination servers, which I am. But I still get the following CDW error message 'Your SQL Server Service is running under local account. You need to change your SQL Server Service account to have the rights to copy the files over the network'. What could be causing this?
April 24, 2003 at 9:07 am
This means to me as below
The sql*server service is running under local system account(control panel-->Administrative Tools-->Services) .
Naturally, this local system account will not have any rights on the network to copy files(as this is local to the PC where sql*server exists).
Try changing the Sql*Server service to run under a domain user account instead of local system account which has sufficient rights on the network.
April 24, 2003 at 10:03 am
What did you select when connecting to both source and destination servers. If you used NT authentication, that might be an issue, else with sql login it should work fine.
April 24, 2003 at 10:09 am
Thanks a mil for pointing me in the right direction.
The solution is :
Change the MSSQLServer and SQLServer Agent service log on to the domain account. Stop and restart both the services.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply