Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have SQL Server 2008R2 installed on my server which I can connect either by providing server name "xyz" or IP address "". Does it mean my installation is done with default instance?

When I am running below query

    ( Value nvarchar(100),
     InstanceNames nvarchar(100),
     Data nvarchar(100))

Insert into @GetInstances
EXECUTE xp_regread
      @rootkey = 'HKEY_LOCAL_MACHINE',
      @key = 'SOFTWARE\Microsoft\Microsoft SQL Server',
      @value_name = 'InstalledInstances'

Select InstanceNames from @GetInstances

and I am getting below result


Now, I have to upgrade SQL Server 2008 R2 to SQL Server 2012. As there are many application which is configured with this database (via server name or IP) , so I don't want to change the database server name. In that case do I need to uninstall SQL Server 2008 first or can I install 2012 and then uninstall 2008?

Eventually, I need to remove SQL Server 2008 from the server Please let me know if any more information is required

share|improve this question
You can just do an in-place upgrade and not worry about it... – Nathan C Jan 30 '14 at 16:57
@NathanC That seems to be pretty good, thank you ! This means my database, roles and other stuff will automatically be upgraded to SQL Server 2012 ? – Zerotoinfinity Jan 30 '14 at 20:56
Read the guide on upgrading for anything that might pertain to your environment. Some things may require configuration. – Nathan C Jan 31 '14 at 13:31
up vote 1 down vote accepted

If you can connect to SQL Server with just the server name, then yes, you are running the default instance of SQL Server. If you need to maintain the same instance(server)name then Nathan C is correct, in-place upgrade is probably going to be the best option.

Supported Version and Edition upgrades TechNet

share|improve this answer
Does that mean that my all databases, their objects (table, view, SP, logins) and server level objects will remain same ? – Zerotoinfinity Jan 31 '14 at 6:43
As long as nothing is using a deprecated feature no longer available in 2012 – Cougar9000 Jan 31 '14 at 15:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.