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
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