+ Reply to Thread
Results 1 to 5 of 5

Find all SQL Server instances on a domain?

  1. Find all SQL Server instances on a domain?


    Hi,

    I am trying to discover all SQL server instances on a client domain. I have
    tried using vbscript with WMI, SQLDMO, LDAP and even using registry key but
    with partial luck.

    I could use isql -L as well but it will not give me the servers that are not
    announced.

    What I am trying to achieve is to identify all SQL server instances (2000
    and 2005) so I could get some detailed report which, then will be used for
    various reviews and checks as well as daily backup, sql jobs reports and so
    on.

    But I can only start doing all that after I have the complete list of all
    SQL Server that I should be looking after.

    Any help would be much appreciated


    Gabriel DBA

  2. Re: Find all SQL Server instances on a domain?

    If you have implemented Active Directory domain in your organization, you
    can:

    1. Register all the sql servers instances in AD.
    2. Search the AD for whatever you like.

    Regards
    --------------

    Robert Lakinski



    "Gabriel" wrote in message
    news:F7F9470F-6620-4698-9F20-2A3A60CCF32Eatmicrosoftdotcom...
    >
    > Hi,
    >
    > I am trying to discover all SQL server instances on a client domain. I
    > have
    > tried using vbscript with WMI, SQLDMO, LDAP and even using registry key
    > but
    > with partial luck.
    >
    > I could use isql -L as well but it will not give me the servers that are
    > not
    > announced.
    >
    > What I am trying to achieve is to identify all SQL server instances (2000
    > and 2005) so I could get some detailed report which, then will be used for
    > various reviews and checks as well as daily backup, sql jobs reports and
    > so
    > on.
    >
    > But I can only start doing all that after I have the complete list of all
    > SQL Server that I should be looking after.
    >
    > Any help would be much appreciated
    >
    >
    > Gabriel DBA



  3. Re: Find all SQL Server instances on a domain?

    From what I've gathered from researching this, the suggestion to publish all
    sql server instances in AD is the only viable solution. When you publish an
    instance it adds a serviceConnectionPoint object to the computer object in
    AD. Then you can query AD for all objects where (LDAP syntax):

    (objectCategory=MS-SQL-SQLServer)

    The instance name is the mS-SQL-Name attribute of the object. You use
    sp_ActiveDiretory_SCP to publish an instance. You can then use
    sp_ActiveDirectory_Obj to publish databases within the instance (if
    desired). The MSSQLServerADHelper service must be enabled (manual start) and
    xp_cmdshell must be enabled. I hope this helps.

    --
    Richard Mueller
    MVP Directory Services
    Hilltop Lab - http://www.rlmueller.net
    --

    "Robert Lakinski" wrote in message
    news:usCXOGdkJHA.2460atTK2MSFTNGP06dotphx.gbl...
    > If you have implemented Active Directory domain in your organization, you
    > can:
    >
    > 1. Register all the sql servers instances in AD.
    > 2. Search the AD for whatever you like.
    >
    > Regards
    > --------------
    >
    > Robert Lakinski
    >
    >
    >
    > "Gabriel" wrote in message
    > news:F7F9470F-6620-4698-9F20-2A3A60CCF32Eatmicrosoftdotcom...
    >>
    >> Hi,
    >>
    >> I am trying to discover all SQL server instances on a client domain. I
    >> have
    >> tried using vbscript with WMI, SQLDMO, LDAP and even using registry key
    >> but
    >> with partial luck.
    >>
    >> I could use isql -L as well but it will not give me the servers that are
    >> not
    >> announced.
    >>
    >> What I am trying to achieve is to identify all SQL server instances (2000
    >> and 2005) so I could get some detailed report which, then will be used
    >> for
    >> various reviews and checks as well as daily backup, sql jobs reports and
    >> so
    >> on.
    >>
    >> But I can only start doing all that after I have the complete list of all
    >> SQL Server that I should be looking after.
    >>
    >> Any help would be much appreciated
    >>
    >>
    >> Gabriel DBA

    >




  4. Re: Find all SQL Server instances on a domain?

    Thanks guys for your suggestions.

    I have found one script on Microsoft Scripting site which did the trick -
    using WMI.

    I wasn't quite sure it would work but the results were fine. Few boxes I
    could not access but that was acceptable.

    Thanks again

    Gabriel DBA


    "Richard Mueller [MVP]" wrote:

    > From what I've gathered from researching this, the suggestion to publish all
    > sql server instances in AD is the only viable solution. When you publish an
    > instance it adds a serviceConnectionPoint object to the computer object in
    > AD. Then you can query AD for all objects where (LDAP syntax):
    >
    > (objectCategory=MS-SQL-SQLServer)
    >
    > The instance name is the mS-SQL-Name attribute of the object. You use
    > sp_ActiveDiretory_SCP to publish an instance. You can then use
    > sp_ActiveDirectory_Obj to publish databases within the instance (if
    > desired). The MSSQLServerADHelper service must be enabled (manual start) and
    > xp_cmdshell must be enabled. I hope this helps.
    >
    > --
    > Richard Mueller
    > MVP Directory Services
    > Hilltop Lab - http://www.rlmueller.net
    > --
    >
    > "Robert Lakinski" wrote in message
    > news:usCXOGdkJHA.2460atTK2MSFTNGP06dotphx.gbl...
    > > If you have implemented Active Directory domain in your organization, you
    > > can:
    > >
    > > 1. Register all the sql servers instances in AD.
    > > 2. Search the AD for whatever you like.
    > >
    > > Regards
    > > --------------
    > >
    > > Robert Lakinski
    > >
    > >
    > >
    > > "Gabriel" wrote in message
    > > news:F7F9470F-6620-4698-9F20-2A3A60CCF32Eatmicrosoftdotcom...
    > >>
    > >> Hi,
    > >>
    > >> I am trying to discover all SQL server instances on a client domain. I
    > >> have
    > >> tried using vbscript with WMI, SQLDMO, LDAP and even using registry key
    > >> but
    > >> with partial luck.
    > >>
    > >> I could use isql -L as well but it will not give me the servers that are
    > >> not
    > >> announced.
    > >>
    > >> What I am trying to achieve is to identify all SQL server instances (2000
    > >> and 2005) so I could get some detailed report which, then will be used
    > >> for
    > >> various reviews and checks as well as daily backup, sql jobs reports and
    > >> so
    > >> on.
    > >>
    > >> But I can only start doing all that after I have the complete list of all
    > >> SQL Server that I should be looking after.
    > >>
    > >> Any help would be much appreciated
    > >>
    > >>
    > >> Gabriel DBA

    > >

    >
    >
    >


  5. Re: Find all SQL Server instances on a domain?

    Hi Gabriel

    If you want to look for "instances installed by stealth" then you may want
    to try SQLPing or SQLRecon at
    http://www.sqlsecurity.com/Tools/Fre...5/Default.aspx which will
    use various methods to determine what instances are running on the network.

    John

    "Gabriel" wrote in message
    news:20AAD79F-28D4-4E72-9F91-71BEDED65E1Fatmicrosoftdotcom...
    > Thanks guys for your suggestions.
    >
    > I have found one script on Microsoft Scripting site which did the trick -
    > using WMI.
    >
    > I wasn't quite sure it would work but the results were fine. Few boxes I
    > could not access but that was acceptable.
    >
    > Thanks again
    >
    > Gabriel DBA
    >
    >
    > "Richard Mueller [MVP]" wrote:
    >
    >> From what I've gathered from researching this, the suggestion to publish
    >> all
    >> sql server instances in AD is the only viable solution. When you publish
    >> an
    >> instance it adds a serviceConnectionPoint object to the computer object
    >> in
    >> AD. Then you can query AD for all objects where (LDAP syntax):
    >>
    >> (objectCategory=MS-SQL-SQLServer)
    >>
    >> The instance name is the mS-SQL-Name attribute of the object. You use
    >> sp_ActiveDiretory_SCP to publish an instance. You can then use
    >> sp_ActiveDirectory_Obj to publish databases within the instance (if
    >> desired). The MSSQLServerADHelper service must be enabled (manual start)
    >> and
    >> xp_cmdshell must be enabled. I hope this helps.
    >>
    >> --
    >> Richard Mueller
    >> MVP Directory Services
    >> Hilltop Lab - http://www.rlmueller.net
    >> --
    >>
    >> "Robert Lakinski" wrote in message
    >> news:usCXOGdkJHA.2460atTK2MSFTNGP06dotphx.gbl...
    >> > If you have implemented Active Directory domain in your organization,
    >> > you
    >> > can:
    >> >
    >> > 1. Register all the sql servers instances in AD.
    >> > 2. Search the AD for whatever you like.
    >> >
    >> > Regards
    >> > --------------
    >> >
    >> > Robert Lakinski
    >> >
    >> >
    >> >
    >> > "Gabriel" wrote in message
    >> > news:F7F9470F-6620-4698-9F20-2A3A60CCF32Eatmicrosoftdotcom...
    >> >>
    >> >> Hi,
    >> >>
    >> >> I am trying to discover all SQL server instances on a client domain. I
    >> >> have
    >> >> tried using vbscript with WMI, SQLDMO, LDAP and even using registry
    >> >> key
    >> >> but
    >> >> with partial luck.
    >> >>
    >> >> I could use isql -L as well but it will not give me the servers that
    >> >> are
    >> >> not
    >> >> announced.
    >> >>
    >> >> What I am trying to achieve is to identify all SQL server instances
    >> >> (2000
    >> >> and 2005) so I could get some detailed report which, then will be used
    >> >> for
    >> >> various reviews and checks as well as daily backup, sql jobs reports
    >> >> and
    >> >> so
    >> >> on.
    >> >>
    >> >> But I can only start doing all that after I have the complete list of
    >> >> all
    >> >> SQL Server that I should be looking after.
    >> >>
    >> >> Any help would be much appreciated
    >> >>
    >> >>
    >> >> Gabriel DBA
    >> >

    >>
    >>
    >>



+ Reply to Thread