Local System Priviledges

  • 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.

    Prashant

    Prashant Thakwanithakwani_prashant@yahoo.co.in

  • Hi,

    When performing a two computer upgrade from SQL Server 6.5 to SQL Server 2000, the account used for the MSSQLSERVER service on both machines should be domain accounts belonging to the Administrators groups of both machines.

    The following quote is from SQL Server 2000 BOL, topic "Preparing to Upgrade from SQL Server 6.5"

    "If performing a two-computer upgrade, assign a domain user name and password to the MSSQLServer service for SQL Server 6.5 and SQL Server 2000 instead of using the local system account or a local user account. The domain user account should belong to the Administrators group of both the computers involved in the upgrade. (The local system account is sufficient for a one-computer upgrade.)"

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_upgrade_5r39.asp

    Later in BOL:

    "To upgrade SQL Server from one computer to another, the two computers must be in the same network domain."

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_upgrade_5r39.asp

    HTH,

    Mike

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply