Folks,
I connect to a large number of SQL Server 2005 databases through SQL Server Management Studio 2005. I frequently check off "Remember password", yet the next time I try to connect it doesn't actually remember it. Have you had this experience? Any workarounds?
我通过SQL Server Management Studio 2005连接到大量的SQL Server 2005数据库。我经常检查“记住密码”,但下次我尝试连接它时实际上并没有记住它。你有这种经历吗?有任何变通方法吗?
3 个解决方案
#1
5
According to the bug report this is a known issue, still not fixed and there is no workaround.
根据错误报告,这是一个已知问题,仍然没有修复,没有解决方法。
#2
0
Here is a workaround that I've used. It's lame, but in the absence of a real fix, this works for me!
这是我使用过的解决方法。这是蹩脚的,但在没有真正修复的情况下,这对我有用!
Add another hostname for the server. An example of this would be, if you are trying to get it to remember the name for "coolserver1" then create yourself a hostname that resolves to the same server but by a different name, perhaps "mycoolserver" or something like that.
为服务器添加另一个主机名。这样做的一个例子是,如果你想让它记住“coolserver1”的名字,那么你自己创建一个主机名,它可以解析为同一个服务器,但名称不同,也许是“mycoolserver”或者类似的东西。
You can do that by adding an entry to your hostfile (c:\windows\system32\drivers\ets\hosts), or by some DNS or other Windows/AD trickery. The point being that you can now address that server by a new "name."
您可以通过向主机文件(c:\ windows \ system32 \ drivers \ ets \ hosts)或某些DNS或其他Windows / AD技巧添加条目来实现此目的。关键是您现在可以通过新的“名称”来寻址该服务器。
Then, use that new name in the connect dialog, with your name/password, and hit the "remember me" checkbox, and it really will remember you :)
然后,在连接对话框中使用新名称,使用您的名称/密码,然后点击“记住我”复选框,它真的会记住你:)
Enjoy!
#3
-1
This happens to me also, but it is most notable when I'm connecting to different servers. If you connect to the same server every time then it should remember your password every time.
这也发生在我身上,但是当我连接到不同的服务器时,这是最值得注意的。如果每次都连接到同一台服务器,那么每次都要记住密码。
Maybe one day, SP3 perhaps, Microsoft will release a nice fix for this somewhat continuous annoyance.
也许有一天,也许是SP3,微软将为这种有点连续的烦恼发布一个很好的解决方案。
#1
5
According to the bug report this is a known issue, still not fixed and there is no workaround.
根据错误报告,这是一个已知问题,仍然没有修复,没有解决方法。
#2
0
Here is a workaround that I've used. It's lame, but in the absence of a real fix, this works for me!
这是我使用过的解决方法。这是蹩脚的,但在没有真正修复的情况下,这对我有用!
Add another hostname for the server. An example of this would be, if you are trying to get it to remember the name for "coolserver1" then create yourself a hostname that resolves to the same server but by a different name, perhaps "mycoolserver" or something like that.
为服务器添加另一个主机名。这样做的一个例子是,如果你想让它记住“coolserver1”的名字,那么你自己创建一个主机名,它可以解析为同一个服务器,但名称不同,也许是“mycoolserver”或者类似的东西。
You can do that by adding an entry to your hostfile (c:\windows\system32\drivers\ets\hosts), or by some DNS or other Windows/AD trickery. The point being that you can now address that server by a new "name."
您可以通过向主机文件(c:\ windows \ system32 \ drivers \ ets \ hosts)或某些DNS或其他Windows / AD技巧添加条目来实现此目的。关键是您现在可以通过新的“名称”来寻址该服务器。
Then, use that new name in the connect dialog, with your name/password, and hit the "remember me" checkbox, and it really will remember you :)
然后,在连接对话框中使用新名称,使用您的名称/密码,然后点击“记住我”复选框,它真的会记住你:)
Enjoy!
#3
-1
This happens to me also, but it is most notable when I'm connecting to different servers. If you connect to the same server every time then it should remember your password every time.
这也发生在我身上,但是当我连接到不同的服务器时,这是最值得注意的。如果每次都连接到同一台服务器,那么每次都要记住密码。
Maybe one day, SP3 perhaps, Microsoft will release a nice fix for this somewhat continuous annoyance.
也许有一天,也许是SP3,微软将为这种有点连续的烦恼发布一个很好的解决方案。