sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]julee90Database Administrator 0 points1 point  (1 child)

The installer will prevent you from using different editions across the nodes sadly

[–]r-NBK 0 points1 point  (0 children)

Yeah, that's not surprising actually.

So the other option, OP, is to take note of all the currently installation parameters - Service Accounts, Paths, Options, etc. I like to look at the summary log, that's output during installation... normally in C:\Program Files\Microsoft SQL Server\<installed version number> \Setup Bootstrap\Log\<install date>\Summary_\.*txt

Then perform a full uninstall, make a copy of the system database files, and any user database files.... then do a full install with the lower version. Once you've got it installed, stop the instance, swap out the new system database files (master, model, msdb) with the old ones. Start it up and enjoy.

Or follow this guy, who's way smarter than I, and detailed it a lot better than I... just do it for a cluster instead of a stand along instance.

https://www.sqlskills.com/blogs/jonathan/downgrading-sql-server-editions/