Upgrade from Web edition to standard edition

[smac99]

Hello, has anyone performed such an in-place upgrade? I installed the web edition on our server only to discover SQL Server Enterprise edition is not compatible with the web edition. Now I want to upgrade the server to Windows Server 2003 Standard edition but I do not want to lose any data/IIS settings/configurations. Anyone know if this is possible?

Thanks in advance!
Sharon

 

[mrdenny]

Save your self some money and go with SQL Standard Edition. Unless you are using the advanced features of Enterprise Edition Standard Edition will work just fine.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[smac99]

sorry, my mistake, I meant SQL Server 2000 Standard Edition. 2K3 Web Edition will not let me install this (only MSDE). I want to do an in place upgrade from Web Edition to Standard Edition. Thanks and sorry for the confusion!

 

[mrdenny]

no problem. An inplace upgrade "shouldn't" be a problem. A full re-install will be much cleaner however.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief