February 22, 2005 at 2:31 am
Hi,
ServerA running SQL Server 2000 Enterprise in Windows 2003 which is in DomainA; ServeB running SQL Server 2000 Enterprise as well but in NT4(sp6) which is in DomainB.
I tried to copy DatabaseA from ServerA to ServerB, but there pop up an error message saying something wrong in the "SQL Server service ... Local System Account".
Would someone give me some help?
Jason
February 22, 2005 at 2:41 am
The default set of NT credentials used by MSSQLSERVER is the Localsystem account. You can check what userid that MSSQLSERVER is running under by looking at control panel/services highlighting MSSQLSERVER and choosing the start-up option.
The Localsystem account has no access to shares on the network as it isn't an authenticated network account.
So, if you want to backup to a network share you have two choices :-
1. Change the account the MSSQLSERVER service runs under to a user account with the relevant network rights.
or
2. Amend the following registry value on the TARGET server and add the sharename you want to dump to - the share does not then authenticate who is coming in and so a Localsystem account will work. The server service on the target server must be re-started before the change takes effect. Note that this effectively removes security on that share, so you need to be careful about what is in the share.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\NullSessionShares
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply