Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

MSSQLFUN

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

What happen, If SQL Server new instance try to use exitsing named instance name?

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.


Comments

Leave a comment on the original post [mssqlfun.com, opens in a new window]

Loading comments...