How to make SQL Server Management Studio use latest version of SQL Server? I'm upgrading my dev machine from Windows 7 to 8. While installing earlier versions of Visual Studio it installed SQL Server 2005. I then went to this site and downloaded and installed SQL Server Management Studio (SQLManagementStudio_x64_ENU.exe file) and then SQL Server 2012 Express (SQLEXPR_x64_ENU.exe file). Then did a mandatory reboot.

But when I load up management studio and do:

SELECT @@VERSION


I'm still getting SQL Server 2005. Any idea how to make it use SQL Server 2012?

EDIT: This is a screenshot of what I'm getting from SQL Config Manager.
Microsoft SQL has several components.  You can install SQL Studio (the GUI you're using), SQL Server itself (the actual database, to which SQL Studio can connect), Analysis Services, Reporting Services, and others.

You currently have a SQL 2005 server running, and you're connecting to it with SQL Studio 2012.  That's OK!  But if you'd rather have a SQL 2012 database on your local machine, you will need to run the SQL 2012 installation process again, and add that component.  You may want to remove the 2005 installation first (backup your database first, of course).

If you've used WAMP or LAMP, what you have is equivalent to installing different versions of MySQL (the database) and PHPMyAdmin (the GUI).  Or Oracle and Toad.