Re: Finding instances of SQL Server does not work properly

On Sat, 19 Nov 2005 11:21:21 +0100, "m.posseth" <michelp@xxxxxxxxxxxxxxx> wrote:

Could not find the reference in the list. I am using VB2005 and .Net 2.0 to do this. Maybe this is
why I cant see it.
I just plugged my laptop into a network which has another instance of SQL on it and now suddenly I
can see the instance on the network and also the one that is on the laptop. Maybe it just does not
work when there is no network connections available but I would have thought it would have used the
local IP address to check as well.

May stick with what I have as I know that when I do publish it the PC on which it will reside will
be connected to the network and have at least 10 servers on it.

>
>Hi John ,
>
>i use DMO for this purpose
>
>set a rerefence to the sql dmo lib and use below code
>Dim sqlObj As New SQLDMO.Application
>
>With sqlObj.ListAvailableSQLServers()
>
>For i As Integer = 0 To .Count
>
>MsgBox(.Item(i))
>
>Next
>
>End With
>
>
>
>regards
>
>michel posseth [MCP]
>
>"John Veldthuis" <johnv@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>news:pkctn1huv1s9t4ocujq8su9283svh1k6ep@xxxxxxxxxx
>>I am trying to find instances of all the SQL servers on the local network
>>including the machine it
>> is running from. The servers will be a mix of SQL2000 and SQL2005 once it
>> is ready. I have been
>> trying it out with the PC on which the program is running also has SQL
>> Server 2005 running on it at
>> the same time but the code will not pick this instance up. I call the
>> following on the Form Load
>>
>> Imports Microsoft.SqlServer.Management.Smo
>>
>> Private Sub GetServers()
>>
>> Dim dtable As DataTable
>> Dim drow as DataRow
>>
>> if myServer <> String.Empty Then
>> cbServers.Items.Add(myServer) ' Add server we are currently
>> using
>> End If
>>
>> dt = SmoApplication.EnumAvailableSqlServers(False) ' this should
>> get the list of servers
>> For Each dro In dtable.Rows
>> ' populate combo box with server list
>> if drow(0).ToString <> myServer then
>> cbServers.Items.Add(drow(0).ToString)
>> Next
>>
>> End Sub
>>
>> The server exists and I can use it if I type in the machine name but the
>> above code fails to detect
>> it.
>>
>> Any help?
>
.

Relevant Pages

  • Re: Odd authentication issues
    ... > I have a laptop that authenticates locally to itself. ... > INSTANCE of SQL on the laptop. ... > time that I am nic'd to my local small business server network). ...
    (microsoft.public.sqlserver.server)
  • No Default Gateway and DNS problems
    ... The other (my laptop) is a Window XP with SP3 which is unable to connect. ... Ethernet adapter Wireless Network Connection: ... The Windows Vista laptop gets the exact same information as my laptop ... - When I use the Windows diagnostic tool, it complains about the DNS servers ...
    (microsoft.public.windowsxp.network_web)
  • Re: Finding instances of SQL Server does not work properly
    ... DMO is to be used with COM interop ... > I just plugged my laptop into a network which has another instance of SQL ... > be connected to the network and have at least 10 servers on it. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Virus that causes a lot of traffic ?
    ... It is MS's network monitoring utility. ... > occured at the 2 servers with the SQL Server SP3. ... machine to infect another machine that has AV to protect it from the ...
    (microsoft.public.windows.server.general)
  • WIN2K3 SP1, SQL Server / MSDTC Issue
    ... I can get SQL Installed ok and everything works fine until I set ... Setup Network Connections (for internal cluster comms and public network) ... Reboot Servers ...
    (microsoft.public.sqlserver.clustering)