Re: Local SQL Server Express Instance not showing up when getting datasource list

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

This might be because (by default) SSEE is not exposed. Try enabling the
SqlBrowser service. You should not need to enable the ports and protocols as
you might not want it to be visible on the LAN.

--
William (Bill) Vaughn
President and Founder Beta V Corporation
Redmond, WA
(425) 556-9205
Microsoft MVP, Author, Mentor
Microsoft MVP
<EvansJunk@xxxxxxxxx> wrote in message
news:1142958264.654063.47950@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi

I'm using System.Data.Sql.SqlDataSourceEnumerator in C# to get the
available servers. It doesn't seem to find any local servers but picks
up 4 others on the local network. I have both SQL Server 2005 and
Express running on my system. The Express is instance named SQLExpress
by default and I can administer the server through SQL Server
Management Studio so I know it's running and whatnot. Any idea why I'm
not seeing my local servers?

code snippet of how I'm retrieving the list:

System.Data.Sql.SqlDataSourceEnumerator m_SqlEnumerator =
System.Data.Sql.SqlDataSourceEnumerator.Instance;
System.Data.DataTable dtblDBList = new System.Data.DataTable();
dtblDBList = m_SqlEnumerator.GetDataSources();


Thanx in advance,
Evan Brown



.

Relevant Pages