Sql-server – Why is the @@Version unchanged after upgrading

installationsql serversql-server-2008-r2upgrade

I have SQL Server 2008 R2. I installed SQL Server 2014 with the option:

Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

and the process ended correctly.

But when running on localhost:

SELECT @@Version

I still have:

Microsoft SQL Server 2008 R2 (SP2) – 10.50.4042.0 (X64)

Sorry if the question is basic but I am very lost at the moment.

Best Answer

I found the problem: The installer I had was just for SQL Server Management Studio, as @MarkSinkinson pointed out.

If you have this same problem, verify you have the correct installation file (not SSMS only, or an incompatible Edition).

Other helpful things to check, from comments originally left on the question:

You may have multiple instances installed, upgraded one of them, and connected to another. Or the upgrade didn't take (this can be easy to dismiss without noticing in the final step of the upgrade wizard). Please note that 2008 and 2008 R2 are completely separate, independent releases.
Make sure that you are connected to right instance in any case.
Check you didn't uncheck the database engine installation option

Related Solutions

Sql-server – Couldn’t install SQL Server 2012 on machine with Windows 7 SP1, VS 2010 SP1

Here's the troubleshooting options I'd try:

Disable antivirus. Man, I hate saying this, but I've seen issues where antivirus took too long to scan a file, and it caused installation problems.
Re-download the installation media. I know you've seen other users run this same setup and it's worked, but I've seen enough corrupt downloads that I would try this anyway. It doesn't cost you anything.
If D is a network share (a mapped drive), copy the installation files locally before you start.

SQL Server Upgrade – Moving from SQL Server 2008 to 2012

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

Best Answer

Related Solutions

Sql-server – Couldn’t install SQL Server 2012 on machine with Windows 7 SP1, VS 2010 SP1

SQL Server Upgrade – Moving from SQL Server 2008 to 2012

Related Question