Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have upgraded my SQL Server 2008 R2 Enterprise edition to SQL Server 2012. Even after upgrade I can see & use SQL Server 2008 R2 instance without any issue. Did my upgrade went fine?

I can open default instance both from SQL Server 2008 and 2012. Also I have updated the compatibility level of all databases to 110.

After in-place upgrade

![enter image description here][1]

Edit - version

After running

SELECT @@Version

SQL Server 2012

Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
    Feb 10 2012 19:39:15 
    Copyright (c) Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

SQL Server 2008 R2

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)   
    Feb 10 2012 19:39:15   
    Copyright (c) Microsoft Corporation  
    Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 
share|improve this question
    
Was it an inplace upgrade? What do you mean by can open default instance both from SQL Server 2008 and 2012 ? –  Kin Feb 4 at 13:05
    
yes it was an in place upgrade and I am able to open both SQL Server 2008 R2 and 2012. Even when I am writing ssms.exe on run it is opening SQL Server 2008 R2 and not 2012.. –  NewAtProgramming Feb 4 at 13:07
    
It is not possible as you might be overlooking some obvious stuff. Open configuration manager and check what service is running. –  Kin Feb 4 at 13:10
    
I have attached the screenshot (programs installed) after in-place upgrade. –  NewAtProgramming Feb 4 at 13:14
    
@Kin I am able to work both on SQL Server 2008 R2 and SQL Server 2012 without any issue. Does it mean that my upgrade went wrong ? –  NewAtProgramming Feb 4 at 13:39

2 Answers 2

up vote 2 down vote accepted

Turning my comments to answer :

SSMS is just a tool to connect to SQL Server.

You did an inplace upgrade, but were connecting to SQL Server 2012 using SSMS 2008R2 and SSMS 2012.

Using T-SQL - will give you the correct version:

SELECT
   SERVERPROPERTY ('MachineName') AS PhysicalMachineName,
   SERVERPROPERTY ('ServerName') AS SQLServerName,
   SERVERPROPERTY ('Edition') AS ServerEdition,
   CAST(SUBSTRING(@@Version,charindex('SQL',@@version, 1),15) AS VARCHAR(255)) +  ' + ' 
       + CAST (SERVERPROPERTY ('productlevel')AS VARCHAR (50)) + ' + (Build'
       + CAST (SERVERPROPERTY ('ProductVersion') AS VARCHAR (50)) +')' AS ProductVersion,
    RIGHT(@@version, (Len(@@Version)-charindex('Windows',@@version, 1))+1) AS [O.S.],
 SERVERPROPERTY ('Collation') AS Collation

Best practice:

  • Before upgrade - run the above script to get the version and after upgrade, run it to make sure that you are on correct right version.
  • Always use the latest version of SSMS (regardless of SQL Server version).
share|improve this answer
    
So basically, my installation went well, it is just upgrade didn't uninstall older IDE. Am I correct ? –  NewAtProgramming Feb 4 at 14:48
    
The upgrade wont uninstall the older version, just will overwrite the binaries. –  Kin Feb 4 at 15:10

I encountered the same issue with 2005 - 2008 R2 upgrade. The solution was to right-click the SSMS icon, and select Find Target. It proved that it still used the old SSMS (2005) instead of the new one. This might be the case for you as well. As for being able to access both 2008 R2 and 2012... that's a bit strange.

share|improve this answer

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.