We have a two Windows 2008 Servers. One running SQL Standard and the other running SQL Enterprise for SSRS.
We need to update the Standard version to Enterprise to enable TDE.
Can we insatll Enterprise SQL side-by-side on the server running Standard and shut down the Standard Instance and run the databases off of the new Enterprise install.
Then on the other server where Enterprise was already installed we want to install SQL standard side-by-side, shutdown Enterprise and run all the Databases and SSRS from the Standard install.
Is this possible? What are the risks?
Thanks in advance. I know this sounds weird and dumb but Money is a huge factor in this one.
We need to update the Standard version to Enterprise to enable TDE.
Can we insatll Enterprise SQL side-by-side on the server running Standard and shut down the Standard Instance and run the databases off of the new Enterprise install.
Then on the other server where Enterprise was already installed we want to install SQL standard side-by-side, shutdown Enterprise and run all the Databases and SSRS from the Standard install.
Is this possible? What are the risks?
Thanks in advance. I know this sounds weird and dumb but Money is a huge factor in this one.