SQL Server 2008 R2 SSMS Default Login Username

Question

I recently created a few test accounts on my server and logged into them using SSMS. When I start SSMS, my default login is now one of the test accounts. How do I clear the login drop down list or reset my account as the default login username?

score 1 · Answer 1 · answered Jul 26 '12 at 22:44

1

Take a look at this blog post: http://blog.sqlauthority.com/2008/11/05/sql-server-clear-drop-down-list-of-recent-connection-from-sql-server-management-studio/

answered Jul 26 '12 at 22:44

Shelly

26
1
5

Wasn't able to find the file that it referenced – Lloyd Banks Jul 27 '12 at 15:37

score 1 · Accepted Answer · edited Jan 22 '13 at 18:01

1

I deleted the sqlstudio.bin file in the folder C:\Users\me\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell. This cleared the SSMS login info

CAUTION - this also removes your server/instance history, not just the default db accounts for the servers

edited Jan 22 '13 at 18:01

Community

1
1

answered Jul 30 '12 at 13:39

Lloyd Banks

35,740
58
156
248

score 0 · Answer 3 · edited May 23 '17 at 10:26

0

If you just want to have a way to quick connect to your favorite databases with saved credentials, then answer was given in this post: https://stackoverflow.com/a/11204012/1249405

edited May 23 '17 at 10:26

Community

1
1

answered Jul 27 '12 at 20:01

Andrei Rantsevich

2,879
20
25

SQL Server 2008 R2 SSMS Default Login Username

3 Answers3