Switching between Database Instances

• arrjay

  Hall of Fame

  Points: 3455

  More actions

  November 27, 2013 at 8:46 am

  #300883

  Hi there - I have installed an instance of SQL2012 and SQL2008 on my machine.

  I would like to access the SQL2008 db instance however every time I open SSMS2008 it defaults to my SQL2012 db insatnce. I want both instances separate from one and other.

  Can someone please let me know how it is possible to open a different version of SQL on the same server instance?

  Thanks!!! Russell.

  --------------------------------------------

  Laughing in the face of contention...

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  November 27, 2013 at 8:54 am

  #1669505

  SSMS will remember the last instance you connected to. So if you run SSMS 2008 and connect to your 20008 instance, that's what it'll default to the same time. And if you run SSMS 2012 and connect to your 2012 instance, it'll remember that separately and you'll default to that instance next time you run SSMS 2012.

  John

• Keith Tate

  SSCrazy Eights

  Points: 9888

  More actions

  November 27, 2013 at 9:03 am

  #1669510

  arrjay (11/27/2013)

  ---

  Can someone please let me know how it is possible to open a different version of SQL on the same server instance?

  When you open SSMS just simply provide the name of the instance you want to connect to:

  servername

  servername\instancename

  Was that your question? If not, maybe I don't understand your question.

  ---

  
  Microsoft Certified Master - SQL Server 2008
  Follow me on twitter: @keith_tate

  Forum Etiquette: How to post data/code on a forum to get the best help[/url]

• arrjay

  Hall of Fame

  Points: 3455

  More actions

  November 27, 2013 at 9:03 am

  #1669509

  Thanks John - This is the issue. I created a default instance for SQL2012 and a named instance for SQL2008. Whenever I connect to my (local) instance it always defaults to my SQL2012 installation.

  Do you know how I connect to my SQL2008 db instance? I guess the question is how do you manage multiple db instance on a single server instance?

  Thanks again. Russell.

  --------------------------------------------

  Laughing in the face of contention...

• arrjay

  Hall of Fame

  Points: 3455

  More actions

  November 27, 2013 at 9:06 am

  #1669511

  Keith! That's what I'm after. Brilliant.

  Thanks again all. Russell.

  --------------------------------------------

  Laughing in the face of contention...

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  November 27, 2013 at 9:06 am

  #1669512

  arrjay (11/27/2013)

  ---

  Thanks John - This is the issue. I created a default instance for SQL2012 and a named instance for SQL2008. Whenever I connect to my (local) instance it always defaults to my SQL2012 installation.

  Do you know how I connect to my SQL2008 db instance? I guess the question is how do you manage multiple db instance on a single server instance?

  Thanks again. Russell.

  Russell

  Just supply the whole name:

  MYSERVER for SQL2012

  MYSERVER\MYINSTANCE for SQL2008

  John

• arrjay

  Hall of Fame

  Points: 3455

  More actions

  November 27, 2013 at 9:08 am

  #1669513

  Cheers John. Thanks for your time on this. Russell

  --------------------------------------------

  Laughing in the face of contention...