I have a hosted VM with about 20 client websites on board. Many use a database which is currently SQL Server 2008 R2 (not an evaluation). Because of upcoming licensing issues, I need to change to the Web Edition of SQL Server with my current host. Is it possible to install SQL Server Web Edition on a box that already has SQL Server 2008 R2 installed?
If it's not possible, could someone suggest best process for this switch?
Best Answer
Multiple SQL Server editions are allowed to be installed on the same box. There will just be choices if you want to minimize your downtime.
Normally SQL Server Editions are installed with the default name so the connect string you are using is likely 192.0.x.x and valid. The new edition will be have to be named something else. 192.0.x.x\MyChoosing or defaults to 192.0.x.x\SQLEXPRESS. This is option will be present during initial install of MSSQL.
Large Downtime Option:
I should note with the large downtime option. If you website depend on something the standard edition uses you will not be able to get your websites back up and your will be down until you remove the options from the websites and for an indefinite period of time.