This article transferred from: Http://zhidao.baidu.com/link?url=V_ Lanovutmin0ku3duamhlsfayfgtz2ioeajh8grnvpozlpd8pudb4iqzl88tnqm9tzlpn5u0vo5k5s-ov7rkk
The same database, when there are multiple logins, the Microsoft SQL Server 2008 Remember password is not good, although the password is automatically come out, but always prompt "Unable to connect to the server, the user name logon failed." ”
Workaround:
clearing the history of SQL Server Management Studio is simple, as long as you delete or rename the file SqlStudio.bin. The file is typically in the following directory: C:\Documents and settings\administrator\application data\microsoft\microsoft SQL server\100 \tools\shell\
If the same problem occurs with SQL Server 2005, you can also try the solutions above. The SQL Server 2005 record login file is Mru.dat, and the path is located in the
C:\Documents and Settings\administrator\application data\microsoft\microsoft SQL server\\tools\shell\ Folder.
Go [MSSQL] SQL Server 2008 Remember password feature