how to launch SQL Management Studio with SA auth mode instead of Windows Auth

1

When ever I launch SQL Management Studio 2014, its connect window opens up with Windows Authentication by default. How do I make it so it should show SA authentication by default?

emrecnl

Posted 2016-12-05T09:08:05.323

Reputation: 394

Answers

0

Add the server(s) you wish to connect to as Registered Servers in SSMS (MSDN page here), then you can specify the authentication so you do not have to change it from Windows to SQL authentication each time you connect.

3N1GM4

Posted 2016-12-05T09:08:05.323

Reputation: 398