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?
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.
You can simply highlight the server name and click DEL on keyboard, same thing for the logins
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With