I was recently using SQL Server 2012 which was connected properly with my SSMS (SQL Server Management Studio). Then I downloaded SQL Server 2016 yesterday and installed it.
Problem is, when I run SSMS, it opens up SQL Server 2012 instead of 2016. How can I make SSMS point to SQL Server 2016?
Thank you!
Are you talking about the version of SSMS you want to use or the default instance?
One is a question that involves changing your windows shortcut, the other probably requires you to lookup the instance name in the SQL Server Configuration tool and using this when you connect
2012:
"C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"2016:
"C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe"config manager 2016:
C:\Windows\SysWOW64\mmc.exe /32 C:\WINDOWS\SysWOW64\SQLServerManager13.msc