Link to home
Start Free TrialLog in
Avatar of George Contrabass
George ContrabassFlag for United States of America

asked on

Upgrading to SQL Server Enterprise license - any downtime?

I intend to upgrade our SSAS server license from standard to Enterprise.


Never done it before and this will be on a production machine.


Is there any downtime involved?


Thank you.

Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

you have to restart sql services to get the new capabilities. A Server restart may be required<

setup.exe /q /ACTION=editionupgrade /InstanceName=MSSQLSERVER /PID=&lt;appropriatePid&gt; /SkipRules=Engine_SqlEngineHealthCheck

Open in new window

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver16
Echo David, you are effectively performing an in place upgrade.

During setup, you would need to select the instance being upgrade

During the process no access to DB.


If you have the option to test in a VM, try.
Avatar of George Contrabass

ASKER

Is there a way to test the in place upgrade without buying the Enterprise license first?
I've got the SSAS instance and data warehouse sitting in VMs now.

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial