Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Change default login SQL Server Management Studio (SSMS)

Some time ago I created a new login to my local SQL Server 2008 Express database server, called "sa_readonly". Now everytime I start SQL Server Management Studio, it displays the "Connect to Server" form, with the default login set to "sa_readonly". This login doesn't exist anymore, and I want to change the default login to "sa". How do i do that?

like image 598
George Avatar asked Feb 24 '12 08:02

George


People also ask

How do I reset SSMS default?

Well, the solution to rest the SSMS layout is very simple. One can do it in split seconds. To restore the default configuration, on the Window menu, click Reset Window Layout.


1 Answers

You can simply highlight the server name and click DEL on keyboard, same thing for the logins

enter image description here

like image 155
Max Avatar answered Sep 24 '22 02:09

Max