SSMS.exe starts sql server management studio 2008 instead of 2012

Question

SSMS.exe starts sql server management studio 2008 instead of 2012

anjaliagarwal5

Ten Centuries

Points: 1267
More actions
January 5, 2017 at 12:57 pm

#339185

Hi All,
I am trying to create a local Instance. When I issue a command ssms.exe from the below directory. It always starts SQL server 2008 which is also installed on my computer. It never start SQL server Management studio 2012. SQL server 2012 is installed on my computer and we are suing this version not sql server 2008.
the directory path is
C:\Program Files\Microsoft SQL Server\110\Tools\Binn\
When I do this
C:\Program Files\Microsoft SQL Server\110\Tools\Binn\> sqlcmd -S (localdb)\MyInstance
1> SELECT @@VERSION;
2> GO
I get the below information
Microsoft SQL Server 2012 - 11.0.2318.0 (X64)
Apr 19 2012 11:53:44
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Is there any way, I can start sql server 2012 instead of 2008.
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Eric M Russell SSC Guru Points: 125561 More actions · Answer 1

See if the solution mentioned in this post, about setting default program for .sql files, also solves your problem.

.. Installation of SSMS 2012 alongside any other existing SSMS installation, such as SSMS 2008 R2 has a problem with setting the default program for opening .SQL files to the new SSMS 2012 version..

http://stackoverflow.com/questions/14564469/opening-sql-files-in-ssms-2012-as-default-program-and-with-existing-instance

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Luis Cazares SSC Guru Points: 183706 More actions · Answer 2

anjaliagarwal5 (1/5/2017)
Hi All,
I am trying to create a local Instance. When I issue a command ssms.exe from the below directory. It always starts SQL server 2008 which is also installed on my computer. It never start SQL server Management studio 2012. SQL server 2012 is installed on my computer and we are suing this version not sql server 2008.
the directory path is
C:\Program Files\Microsoft SQL Server\110\Tools\Binn
When I do this
C:\Program Files\Microsoft SQL Server\110\Tools\Binn\> sqlcmd -S (localdb)\MyInstance
1> SELECT @@VERSION;
2> GO
I get the below information
Microsoft SQL Server 2012 - 11.0.2318.0 (X64)
Apr 19 2012 11:53:44
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Is there any way, I can start sql server 2012 instead of 2008.
Thanks

@@VERSION will show the version of the instance to which you're connected. It has nothing to do with SSMS. If you have 2 instances running, be sure to connect to the correct instance.

By the way, 2008 is version 100.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Eric M Russell SSC Guru Points: 125561 More actions · Answer 3

Yeah, go under Help.. About.. menu to see the version of SSMS you're running.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 4

anjaliagarwal5 (1/5/2017)
Hi All,
I am trying to create a local Instance. When I issue a command ssms.exe from the below directory. It always starts SQL server 2008 which is also installed on my computer. It never start SQL server Management studio 2012. SQL server 2012 is installed on my computer and we are suing this version not sql server 2008...

if you're typing ssms.exe in a command window to start it, the problem may be the order of the directories in your PATH environment variable:

http://www.geekswithblogs.net/renso/archive/2009/10/21/how-to-set-the-windows-path-in-windows-7.aspx