且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

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

更新时间:2022-06-20 22:41:01

这里的另一个答案也提到了自 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!