Problem Upgrading from MS SQL 7.0 to MS SQL 2000 (upgrade option disabled)

Ladies & Gentlemen,

I realize this must be an unexpected question in this day and age of MS SQL 2005, however, at my company i need to upgrade from SQL 7.0 to SQL 2000 standard on a WIN2K machine.

can anyone out there tell me why the option to upgrade ("Upgrade, remove, or add components to an existing installation of SQL Server") is disabled ?

I'm reading that i should be able to upgrade without having to install a second instance.

thank you

It depends of SQL 7.0 edition. It the editon is diferent than Enterprise than upgrade should work. It is not allowed to upgrade SQL 7.0 Enterprise to SQL 2000 Standard.

|||

thank you,

i am trying to upgrade from Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86) (standard edition)

but my IT admin gave me SQL 2000 personal edition. I now have the SQL 2000 Standard edition and it is working.

thanks again