如何从“连接到服务器"对话框中删除缓存的服务器名称? [英] How to remove cached server names from the Connect to Server dialog?

问题描述

或者，换句话说，用于SQL Server 2012的SqlStudio.bin在哪里?通过查看另一个SO问题，它似乎并没有达到预期的位置.

Or, to put it another way, where is SqlStudio.bin for SQL Server 2012? It doesn't seem to be in the place that would be expected by looking at this other SO question.

推荐答案

从SQL Server 2012开始，您不再需要麻烦删除bin文件(这会导致其他副作用).您应该能够在连接到服务器"对话框的服务器名称"下拉列表的MRU列表中按 Delete 键. 此连接项中对此进行了记录和

As of SQL Server 2012 you no longer have to go through the hassle of deleting the bin file (which causes other side effects). You should be able to press the Delete key within the MRU list of the Server Name dropdown in the Connect to Server dialog. This is documented in this Connect item and this blog post.

要清楚，因为几个人似乎几个月都遇到了麻烦:您需要单击Server name:下拉列表，然后用鼠标向下箭头或悬停，直到选择了要删除的服务器. ，然后 then 按 Delete .在此屏幕快照中，我现在要按 Delete ，它将从我的MRU列表中删除服务器ADMIN:SHELDON\SQL2014.请注意，因为我只是用鼠标悬停，所以Server name:文本框中显示的甚至不是服务器.

To be clear, since a couple of people seemed to have trouble with this for months: You need to click on the Server name: dropdown, and down-arrow or hover with your mouse until the server you want to remove is selected, and then press Delete. In this screen shot, I'm going to press Delete now, and it will remove the server ADMIN:SHELDON\SQL2014 from my MRU list. Note that because I merely hovered with my mouse, this is not even the server that is showing in the Server name: text box.

请注意，如果您为一个服务器名拥有多个条目(例如，对于Windows来说是一个条目，而对于SQL Auth来说是一个条目)，则您将无法确定要删除的条目.

Note that if you have multiple entries for a single server name (e.g. one with Windows and one with SQL Auth), you won't be able to tell which one you're deleting.

这篇关于如何从“连接到服务器"对话框中删除缓存的服务器名称?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！