在 SQL Server Management Studio 中删除记住的登录名和密码列表

2021-12-13 00:00:00 security login sql-server ssms

我最近在维修我公司的备用笔记本电脑时使用了它(设置了普通用户).登录数据库时，我已选中 SQL Server Management Studio 中的记住密码"选项.

I've recently used our company's spare laptop (that has a general user set up) while mine was being repaired. I've checked the "Remember password" option in SQL Server Management Studio when logging in to the database.

我需要清除我使用过的登录名和密码信息，以防止下一个使用笔记本电脑的人使用我的登录名和密码.我该怎么做?

I need to clear the login and password information that I have used to prevent the next person that will use the laptop from using my login names and passwords. How can I do this?

推荐答案

这里的另一个答案也提到了自 2012 年以来您可以通过 如何从连接到服务器"对话框中删除缓存的服务器名称?.刚刚确认 MRU 列表中的此删除在 2016 年和 2017 年工作正常.

Another answer here also mentions since 2012 you can remove Remove cached login via How to remove cached server names from the Connect to Server dialog?. Just confirmed this delete in MRU list works fine in 2016 and 2017.

SQL Server Management Studio 2017 删除文件C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio14.0SqlStudio.bin

SQL Server Management Studio 2017 delete the file C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio14.0SqlStudio.bin

SQL Server Management Studio 2016 删除文件C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio13.0SqlStudio.bin

SQL Server Management Studio 2016 delete the file C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio13.0SqlStudio.bin

SQL Server Management Studio 2014 删除文件C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio12.0SqlStudio.bin

SQL Server Management Studio 2014 delete the file C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio12.0SqlStudio.bin

SQL Server Management Studio 2012 删除文件C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio11.0SqlStudio.bin

SQL Server Management Studio 2012 delete the file C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio11.0SqlStudio.bin

SQL Server Management Studio 2008 删除文件 C:Users\%username%AppDataRoamingMicrosoftMicrosoft SQL Server100ToolsShellSqlStudio.bin

SQL Server Management Studio 2008 delete the file C:Users\%username%AppDataRoamingMicrosoftMicrosoft SQL Server100ToolsShellSqlStudio.bin

SQL Server Management Studio 2005 删除文件 - 与上述答案相同，但使用 Vista 路径.C:Users\%username%AppDataRoamingMicrosoftMicrosoft SQL Server90ToolsShellmru.dat

SQL Server Management Studio 2005 delete the file – same as above answer but the Vista path. C:Users\%username%AppDataRoamingMicrosoftMicrosoft SQL Server90ToolsShellmru.dat

这些是 Vista/7/8 的配置文件路径.

These are profile paths for Vista / 7 / 8.

注意，AppData 是一个隐藏文件夹.您需要在资源管理器中显示隐藏文件夹.

Note, AppData is a hidden folder. You need to show hidden folders in explorer.

您可以简单地从服务器/用户名下拉列表中按删除(已确认适用于 SSMS v18.0).原始来源 https://blog.sqlauthority.com/2013/04/17/sql-server-remove-cached-login-from-ssms-connect-dialog-sql-in-sixty-seconds-049/ 其中提到此功能自 2012 年开始可用！

You can simply press delete from the Server / User name drop down (confirmed to be working for SSMS v18.0). Original source from https://blog.sqlauthority.com/2013/04/17/sql-server-remove-cached-login-from-ssms-connect-dialog-sql-in-sixty-seconds-049/ which mentioned that this feature is available since 2012!

相关文章