SQL Server 2008 R2 SSMS Default Login Username

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?

  • Select a random date within specific range
  • SQL Server 2012 - Create Data Type from existing table
  • Is it better to use one or many contexts
  • DELETE command times out
  • ASP.Net insert data from Textbox to a database
  • Creating a Per-User dynamic connection string for ASP.NET website connecting to a SQL Server database
  • 3 Solutions collect form web for “SQL Server 2008 R2 SSMS Default Login Username”

    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

    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:

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.