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.
MACHINENAME\SQLEXPRESS
which defaults to 2005, but then I have to click browse and pickMACHINENAME
which is 2012. Btw, is there any way to rename them?.\SQLEXPRESS
and.
). To rename an instance, you install a new one, move your databases and other settings over, and then remove the old one. Also SSMS only shows you instances you've connected to before. You can just type in a server instead of using browse if you've never connected to that instance before.