Set a default login when opening SSMS 2005

• Melissa.Fischer

  SSC-Addicted

  Points: 421

  More actions

  March 9, 2010 at 8:40 am

  #230743

  SSMS, Query Analyzer, Object Explorer - we use multiple SQL logins but would always like it to default to one specific one.

  So each time the developer would open a new session in SSMS or Query, it would default to say 'DevSU' as the SQL login even if the user last used a 'DevUser' login.

  The two logins are specific to what the developer is doing at the time, but I would always like it to default to 'DevUser'.

  Can't find where I can put that in the SSMS options or the registry and if the registry would I have to have that done per user installation.

  Inquiring minds want to know.

• Renuka__

  Hall of Fame

  Points: 3656

  More actions

  March 9, 2010 at 8:51 am

  #1130723

  Hi,

  While registering the server in SSMS, if you use the login(DevUser) that you want, it always opens through that login until you unregister it.

  [font="Verdana"]Renuka__[/font]