Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

When I am running below query

DECLARE @GetInstances TABLE
    ( 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

MSSQLSERVER
MSSQLSERVER_2

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 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 ? –  Zerotoinfinite Jan 30 at 20:56
1  
Read the guide on upgrading for anything that might pertain to your environment. Some things may require configuration. –  Nathan C Jan 31 at 13:31

1 Answer 1

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 ? –  Zerotoinfinite Jan 31 at 6:43
    
As long as nothing is using a deprecated feature no longer available in 2012 –  Cougar9000 Jan 31 at 15:04

Your Answer

 
discard

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.