清除SQL Server 2008记住的数据库地址、登录名和密码

在服务器上登录过数据库信息,并且选择了记住了密码,由于服务器数据库很多人在使用,有必要删除信息

定位到fileC:Users\%username%AppDataRoamingMicrosoftMicrosoft SQL Server100ToolsShellSqlStudio.bin,确保已经关闭SQL Server ,把
SqlStudio.bin删除掉,再重新打开就完全清除数据库地址、登录名和密码。


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

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

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

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

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

SQL Server Management Studio 2005 delete the file – same as above answer but the Vista path. C:Users\%username%AppDataRoamingMicrosoftMicrosoft SQL Server90ToolsShellmru.dat
参考:
How to remove cached server names from the Connect to Server dialog
Removing the remembered login and password list in SQL Server Management Studio
学习,以记之。如有错漏,欢迎指正

作者:冯子武
出处:http://www.cnblogs.com/Zev_Fung/
本文版权归作者和博客园所有,欢迎转载,转载请标明出处。
如果博文对您有所收获,请点击下方的 [推荐],谢谢

原文地址:https://www.cnblogs.com/Zev_Fung/p/8531515.html