I’ve grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It’s a fairly human look at what’s involved in sailing on a Trident missile submarine…
We all know that SQL Server can have 1 default instance & many named instance.
But I want to check, How SQL Server Setup behave, If I tries to use instance name that is already being used by some existing SQL server on my system.
I am already having 2 instances running on my system, 1 SQL Server 2008 & 1 SQL Server 2012.
I must say, SQL Server setup is too cleaver. It shows me that instance that use the name (passed by me) & show me a SQL server version of that instance as well.
In same way, It works for both default & Named instance.
1) While installing 3rd instance of SQL Server 2005, I pass the instance name used by SQL Server 2008.
2) While installing 3rd instance of SQL Server 2005, I pass the instance name used by SQL Server 2012.