April 26, 2004 at 12:59 am
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
April 28, 2004 at 12:02 pm
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