问题描述
我使用SMO找到network.But可用sqlservers在一台机器在那里我运行
I am using SMO to find available sqlservers of a network.But in one machine where i running
应用它亘古不给默认实例名也是所有其他机器它给出了
application it doesnot give Default instance name but for all other machines it gives the
命名和默认实例西港岛线展示。
named and default instance wil be showing.
观察我的方案。
例如：机器名称：rkwrk3-VM-SR（本地计算机从那里我运行的应用程序，其中
Ex: Machine Name :rkwrk3-vm-sr (local machine from where i am running app in which
SQLSERVER2008安装）
sqlserver2008 installed)
在此其实我已经SQL2008作为默认实例和SQLEXPRESS（2005）命名实例...
in this actually i have sql2008 as default instance and sqlexpress(2005) as named instance...
但是，只显示一个实例rkwrk3-VM-sr\sqlexpress，它亘古不变的ahows rkwrk3-VM-SR。
But it shows only one instance rkwrk3-vm-sr\sqlexpress and it doesnot ahows rkwrk3-vm-sr.
和其他一些机器HR-2K3-TM（其中安装SQLSERVER2005 ）
and some other machines Hr-2k3-tm(where sqlserver2005 installed)
这是显示HR-2K3-TM和HR-2K3-TM / SQLEXPRESS
for this it is showing Hr-2k3-tm and Hr-2k3-tm/sqlexpress
如何我能解决这个问题。任何帮助WIL Greately赞赏。
How can i fix this .Any Help wil Greately Appreciated.
在此先感谢。
推荐答案
实例发现协议（UDP的1434上）由，默认情况下被禁用（在一个名为的 ...）。
The instance discovery protocol (the UDP on 1434) is served by the SQL Browser service, which by default is disabled (in memory of a thing named Slammer...).
请确保该服务已启用，并开始在所有机器上。
Make sure the service is enabled and started on all machines.
这篇关于SmoApplication.EnumAvailableSqlServers（）如果SQLEXPRESS是在安装SQLSERVER2008同一台机器上没有列出默认实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！