Friday, March 9, 2012

local system privildges

I am trying to upgrade the SQL Server 6.5 on one server to SQL
Server2000 on the other machine.

At that time, i am getting the following error:

"The local SQL Server is running under localsystem priviledges,
preventing the upgrade wizard to connect to the export server."

I am logged on thru the administrator on both the machines.

Pls tell how to to eradicate this error, so that my upgrade is
successful.

Thanks in advance.thakwani@.rediffmail.com (Prashant Thakwani) wrote in message news:<bf0d42bf.0404252301.780bce11@.posting.google.com>...
> I am trying to upgrade the SQL Server 6.5 on one server to SQL
> Server2000 on the other machine.
> At that time, i am getting the following error:
> "The local SQL Server is running under localsystem priviledges,
> preventing the upgrade wizard to connect to the export server."
> I am logged on thru the administrator on both the machines.
>
> Pls tell how to to eradicate this error, so that my upgrade is
> successful.
>
> Thanks in advance.

During the upgrade, the SQL2000 server needs to connect to the
filesystem on the SQL6.5 server. This is not possible if the MSSQL
service is running as LocalSystem, because LocalSystem has no network
access. You should consider changing your SQL2000 installation to run
using a domain account, instead of LocalSystem - this is recommended
anyway, as some functionality requires a domain account, and it's also
possible to limit the permissions of the service account, which is
better for security.

See "Setting up Windows Services Accounts" and "Changing Passwords and
User Accounts" in Books Online.

Simon

No comments:

Post a Comment