清除SQL Server 2008記住的資料庫地址、登入名稱和密碼

標籤：sof   file   removing   href   microsoft   vista   name   gem   清除資料   

在伺服器上登入過資料庫資訊，並且選擇了記住了密碼，由於伺服器資料庫很多人在使用，有必要刪除資訊

定位到fileC:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin，確保已經關閉SQL Server ，把SqlStudio.bin刪除掉，再重新開啟就完全清除資料庫地址、登入名稱和密碼。

SQL Server Management Studio 2017 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\14.0\SqlStudio.binSQL Server Management Studio 2016 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\13.0\SqlStudio.binSQL Server Management Studio 2014 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.binSQL Server Management Studio 2012 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.binSQL Server Management Studio 2008 delete the fileC:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.binSQL Server Management Studio 2005 delete the file – same as above answer but the Vista path. C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.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

清除SQL Server 2008記住的資料庫地址、登入名稱和密碼