sql server profiler 不会记住密码

weixin_38061732 2016-05-22 10:30:33

即使我登录前选择记住密码，但退出后再次打开时还需要输入密码

发现通过sql server>工具打开sql server profiler 要求输入密码，但我切换下服务器名称后就有密码了，问题是出在首次打开sql server profiler 没有加载密码，这应该是bug吧?
操作系统 win10专业版, sql server 2012

One world, one dream!

...全文

14 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

weixin_38062262 2016-05-23

打赏
举报

看是不是这里没有权限写入数据，或是数据被删除了
SQL Server Management Studio 2008
C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

SQL Server Management Studio 2005
C:\Users\%username%\AppData\Roaming \Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat
参考项
http://stackoverflow.com/questions/349668/removing-the-remembered-login-and-password-list-in-sql-server-management-studio
摘抄内容
SQL Server Management Studio 2014 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin
SQL Server Management Studio 2012 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin
SQL Server Management Studio 2008 delete the file
C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin
SQL 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
These are profile paths for Vista / 7 / 8.
专注于.NET ERP/CRM开发框架，C/S架构，SQL Server + ORM(LLBL Gen Pro) + Infragistics WinForms

weixin_38113326 2016-05-23