enumerating registered sqlservers does not fill datatable complete

I've tried to enumerate sqlservers using two different methods and have the
same results... only the server name is returned, I am unable to get the
instance name so user will be unable to connect to selected server if it is
a
named instance (i.e. "Server"\SQLEXPRESS)...
Dim dt As DataTable
dt = SmoApplication.EnumAvailableSqlServers(False)
OR
Dim dt As DataTable
Dim instance As Sql.SqlDataSourceEnumerator =
Sql.SqlDataSourceEnumerator.Instance
dt = instance.GetDataSources
However I can go into SQL Server Management Studio, browse for servers and
every instance for every server (local and network) is listed... I assume
(foolishly) that MS Apps utilize thier own sdk's, if so why does it work
there but not for meOK I think I've found the culprit... the "Windows Firewall/Internet
Connection Sharing (ICS)" service
When I stop this service the enumerations return the Instance name and
Version of the SQL Servers... Hooray but what if Users have this service
running during my application installation? I'm suprised this isn't more of
a
known issue... I'm able to duplicate the issue on 2 machines both running XP
sp2 where one has SQL Server Express 2005 then other has SQL Server Express
2005 SP1, same results. Has anyone heard or exprienced this?

> I've tried to enumerate sqlservers using two different methods and have th
e
> same results... only the server name is returned, I am unable to get the
> instance name so user will be unable to connect to selected server if it i
s a
> named instance (i.e. "Server"\SQLEXPRESS)...
> Dim dt As DataTable
> dt = SmoApplication.EnumAvailableSqlServers(False)
> OR
> Dim dt As DataTable
> Dim instance As Sql.SqlDataSourceEnumerator =
> Sql.SqlDataSourceEnumerator.Instance
> dt = instance.GetDataSources
> However I can go into SQL Server Management Studio, browse for servers and
> every instance for every server (local and network) is listed... I assume
> (foolishly) that MS Apps utilize thier own sdk's, if so why does it work
> there but not for me|||On Tue, 13 Jun 2006 14:17:02 -0700, rqcoder
<rqcoder@.discussions.microsoft.com> wrote:
in <EF3759A0-3FE7-4839-B10E-E892752C02AB@.microsoft.com>

>OK I think I've found the culprit... the "Windows Firewall/Internet
>Connection Sharing (ICS)" service
>When I stop this service the enumerations return the Instance name and
>Version of the SQL Servers... Hooray but what if Users have this service
>running during my application installation? I'm suprised this isn't more of
a
>known issue... I'm able to duplicate the issue on 2 machines both running X
P
>sp2 where one has SQL Server Express 2005 then other has SQL Server Express
>2005 SP1, same results. Has anyone heard or exprienced this?
It happens on any machine that's running the firewall. It looks like
the tolerance window for the enumerations is extremely small - less than
a second. If anything hampers that initial query in the slightest then
the instance names don't show up. And I'm describing SQLDMO behavior
using VB6 but the enumerations code is most likely the same or extremely
similar.
What works well for me is Kerio Personal Firewall with specific rules
but that doesn't always wash well in the general user community.
Stefan Berglund

Enterprise Manager Won't Run

I am unable to start my Enterprise Manager. I get the following error message:
"Microsoft Management Console has encountered a problem and needs to close".
This is a SQL 2000 system.
This happened one day for no apparent reason. I use SQL Enterprise Manager
everyday. I have uninstalled and reinstalled the product and have the same
problem.
Help is appreciated. Thanks.
Hi
Have you tried to run MMC on it's own and then open up the SQL Server
Enterprise Manager MMC?
John
"john" <john@.discussions.microsoft.com> wrote in message
news:4AA5174A-D9C1-4FA1-979C-3DAC67521A14@.microsoft.com...
>I am unable to start my Enterprise Manager. I get the following error
>message:
> "Microsoft Management Console has encountered a problem and needs to
> close".
> This is a SQL 2000 system.
> This happened one day for no apparent reason. I use SQL Enterprise Manager
> everyday. I have uninstalled and reinstalled the product and have the same
> problem.
> Help is appreciated. Thanks.
|||Yes, I can start say Computer Management which uses the MMC and it opens just
fine. I can leave it open and then try to start the Enterprise Manaer and i
get the same problem. I am not sure if they use the same version of the MMC
or not.
"John Bell" wrote:

> Hi
> Have you tried to run MMC on it's own and then open up the SQL Server
> Enterprise Manager MMC?
> John
> "john" <john@.discussions.microsoft.com> wrote in message
> news:4AA5174A-D9C1-4FA1-979C-3DAC67521A14@.microsoft.com...
>
>
|||Hi
You can therefore try and open the SQL Server Enterprise Manager.mmc from
the tools (or the tools/html) directory.
You could try copying the file from another machine and possibly renaming
it, if it continues to cause an issue.
John
"john" <john@.discussions.microsoft.com> wrote in message
news:C9132729-931C-488D-9F96-63AB177CA33D@.microsoft.com...[vbcol=seagreen]
> Yes, I can start say Computer Management which uses the MMC and it opens
> just
> fine. I can leave it open and then try to start the Enterprise Manaer and
> i
> get the same problem. I am not sure if they use the same version of the
> MMC
> or not.
>
> "John Bell" wrote:
|||I tried copying the MMC from another computer that can run enterprise Manager
and i had the same problem. Then I renamed it as you siuggested and now it
will run. That seems so strange. Any ideas why this works?
thanks for your help
john
"John Bell" wrote:

> Hi
> You can therefore try and open the SQL Server Enterprise Manager.mmc from
> the tools (or the tools/html) directory.
> You could try copying the file from another machine and possibly renaming
> it, if it continues to cause an issue.
> John
> "john" <john@.discussions.microsoft.com> wrote in message
> news:C9132729-931C-488D-9F96-63AB177CA33D@.microsoft.com...
>
>
|||Did you try to register a custom MMC ? Open Managment Console, File
Add/Remove Snappin, Add , SQL Server Enterprise Manager
Save the Console under a known destination path, try to open it from
this msc file.
Would be interesting if the problems occurs after creating this custom
console.
HTH, jens Suessmeyer.