How to open both 2008 and 2012 sql server on same machine | Code By Topic

How to open both 2008 and 2012 sql server on same machine


Open 2008 & 2012 in Same Machine
I have installed both SQL Server 2008 and SQL Server 2012 then how i open both on same machine?

Yes it may be possible that you have to install both version because in one server only 2008 work but in another server or another client have SERVER 2012 then off-course you have both in your local server. But lets suppose you have installed SQL Server 2008 and after some day or some month you installed SQL Server 2012 After installation.Then key question is how to open SQL Server different instance in Same machine? when you open SQL Server with run command then its opened the 2008 not new version or vice versa. Then i have the query to open SQL Server as you want.

Code Sample [SQL Server Query]
Go to run and paste below command
For SQL Server 2008
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
And the 2012 management studio exe is here:
"C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

You can also open this by go to above mention path like
C=>Program Files (x86)=>Microsoft SQL Server=>100=>Tools=>Binn=>VSShell=>Common7=>IDE
and click the ssms


After this press ok then below screen display


Post a Comment