我的电脑上有 2 个 Sql Server 实例：
一个 Sql Express 的命名实例 (\SQLEXPRESS)
和一个 Sql Developer 版本的默认实例。
使用 SSMS，当我在我的计算机上浏览服务器时，我只得到在我的计算机上列出的可用的 Sql Express 实例。
我知道我已配置并可访问服务器本身，因为如果我手动键入连接字符串，我可以在本地和其他计算机上通过 Sql 身份验证和 Windows 身份验证连接到它。我知道 Sql 浏览器至少会返回一些信息，因为 Sql Express 实例是可浏览的。
经过一些谷歌搜索解决方案后，我能找到的最接近我的问题的信息是这个 MSDN 文章。然而，据我所知，自从安装操作系统（Win 7 x64）以来我就没有更改过我的计算机的名称，更不用说自从安装了Sql之后。
关于为什么浏览器无法识别其他实例的任何想法都非常感谢。
谢谢安迪
I have 2 instances of Sql Server on my pc:
A named instance of Sql Express (\SQLEXPRESS)
And a default instance of Sql Developer edition.
Using SSMS, when I browse for servers on my machine, I only get the Sql Express instance listed as being available on my machine.
I know that I have the server itself configured and accessible because if I type the connection string manually, I can connect to it via Sql Authentication and Windows Authentication both locally and from other machines. And I know the Sql Browser is at least returning some information as the Sql Express instance is browsable.
After some googling for a solution, the closest information I can find to my problem is this MSDN Article. However, as far as I know, I haven't changed the name of my computer since the OS was installed (Win 7 x64) let alone since Sql was installed.
Any ideas about why the browser doesn't recognise the other instance greatly appreciated.
Thanks Andy
发布评论
评论（1）
如果两个实例的 HideInstance Flag 均为 No 并且仍未显示
查看SO 和 DBA.Stackexchange
并尝试这个注册表项
确保其值为
1如果您在 90 文件夹下找不到它，请搜索
SsrpListener，因为如果您阅读了 SQL Browser服务 ，你会看到浏览器服务最初是SQL Server解析协议（SSRP）if the HideInstance Flag is No for both the instances and still not showing
check out these 2 Posts in SO and DBA.Stackexchange
and try this registry Key
make sure it has value
1if you cant find it under 90 folder, search for
SsrpListenerbecause if you read the background section of SQL Browser service , you see that browser service was originally SQL Server Resolution Protocol (SSRP)