SQL Server – Install Standalone Instance on Cluster Server

clusteringsql server

I've a cluster instance in 2016 SP1 version on Windows 2016 server. All work fine.
I want to install a new instance in standalone mode (version 2008) on one server of this cluster. The data disk of this new instance will be localdisk.

I want to know if the standalone installation will work without broke or impact cluster instance.

Best Answer

It is a hell of a bad idea, but it might work. I have done something similar in the past because it was the only possible solution and I can confirm that it works.

The only thing to be careful about is the versions: you will probably get warnings about installing sql server 2008 on Windows 2016. Also, keep in mind that it's not supported (which doesn't mean it won't work).

However, this is something I would never do in production: do yourself a favour and find a different machine for that SQL Server 2008 standalone instance: at least, you won't get shared features incompatibilities and the like.