Cannot see an instance with BrowseConnect or OSQL /L

Hi,
I have 3 instances of SQL server currently on my machine. The default
instance is MSDE 2000, I also have an SQL Express 2005 instance
\MACHINE\SQLEXPRESS and I have an instance of SQL Server 2000 Workgroup
Edition, named \MACHINE\WORKGROUP. When I execute SqlBrowseConnect or
"ListAllAvailableInstances" from SQL-DMO methods, I can see the 2005
instance and the default instance (local), but not the workgroup instance.
When I execute OSQL /L, I get the same result. I cannot see the Workgroup
Instance. I can however connect to the workgroup instance via. management
studio and can register it with SQL Server Configuration Manager.
I can connect to it via. OSQL and execute statements however, if I specify
the instance name on the command line. Any ideas on why it isn't visible?
According to connection properties in Management Studio (Server
Properties -> Connections), "allow remote connections" is switched on.
Robin
Okay, I fixed this by using the registry for local enumeration. Still, it's
a bit suprising to me that the browser won't enumerate all local instances -
or at least that there isn't a solid mechanism for doing so apart from
accessing the registry.
"Robinson" <toomuchspamhaspassed@.myinboxtoomuchtoooften.com > wrote in
message news:ego20b$g7q$1$830fa17d@.news.demon.co.uk...
> Hi,
> I have 3 instances of SQL server currently on my machine. The default
> instance is MSDE 2000, I also have an SQL Express 2005 instance
> \MACHINE\SQLEXPRESS and I have an instance of SQL Server 2000 Workgroup
> Edition, named \MACHINE\WORKGROUP. When I execute SqlBrowseConnect or
> "ListAllAvailableInstances" from SQL-DMO methods, I can see the 2005
> instance and the default instance (local), but not the workgroup instance.
> When I execute OSQL /L, I get the same result. I cannot see the Workgroup
> Instance. I can however connect to the workgroup instance via.
> management studio and can register it with SQL Server Configuration
> Manager.
> I can connect to it via. OSQL and execute statements however, if I specify
> the instance name on the command line. Any ideas on why it isn't visible?
> According to connection properties in Management Studio (Server
> Properties -> Connections), "allow remote connections" is switched on.
>
> Robin
>