526互联

Removing the remembered login and password list in SQL Server Management Studio

发布时间 2023-08-01 17:18:20作者: ChuckLu

Removing the remembered login and password list in SQL Server Management Studio

This works for SQL Server Management Studio v18.0

The file "SqlStudio.bin" doesn't seem to exist any longer. Instead my settings are all stored in this file:

C:\Users\*********\AppData\Roaming\Microsoft\SQL Server Management Studio\18.0\UserSettings.xml

  • Open it in any Texteditor like Notepad++
  • ctrl+f for the username to be removed
  • then delete the entire <Element>.......</Element> block that surrounds it.

    <ConnectionOptions>
      <LastServerType>8c91a03d-f9b4-46c0-a305-b5dcc79ff907</LastServerType>
      <LastAuthenticationMethod>1</LastAuthenticationMethod>
      <ServerTypes>
        <Element>
          <Key>
            <guid>8c91a03d-f9b4-46c0-a305-b5dcc79ff907</guid>
          </Key>
          <Value>
            <ServerTypeItem>
              <Servers>

 

下面这个可用

EDIT: An even easier and working solution for v18.0 (Preview 7) would be:

  • Go to the "Connect to Server" dialogue window:

  • Click the down-arrow icon marked green in the screenshot.

  • Use the arrow-keys on the keyboard to navigate up/down

  • Press the DEL key on keyboard to delete the entry.

  • Close the dialogue window and when you reopen it the entry will indeed be removed.