Re: How can I scan for named instances of SQL?

Have you checked out SQL Scan which is now part of the SQL Server 2000
Security Tools?

See
http://www.microsoft.com/downloads/details.aspx?familyid=9552d43b-04eb-4af9-9e24-6cde4d933600&displaylang=en


joe.


"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:%23ocjkavMGHA.3936@xxxxxxxxxxxxxxxxxxxxxxx
Byron
Do you use SQLDMO objects library?

The OLE DB Provider for SQL Server 2000 returns instance names using
ISourcesRowset::GetSourcesRowset

SQL-DMO applications can enumerate instances using the SQLServer2
object. The SQLServer2 object also presents information such as the names
of
the SQL Server and SQL Server Agent services for the instance, or whether
the instance is running on a single computer or a failover cluster. For
more
information, see SQLServer2 Object





"Byron" <Byron@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:74EC9B24-45FE-4A8D-B0CF-E5DB412C3E70@xxxxxxxxxxxxxxxx
I need to periodically scan our network for SQL installations and
sometimes
affect all servers to do things like change the sa password. Since the
servers are far-flung without technical people on-site I can't rely on
anyone
there to keep me up to date. I wrote a little C# app that can locate all
the
default instances, but it can't discover named instances.

Ideally I'd like to add the capability to discover named instances to the
samer application, but any other discovery method would be appreciated.




.

Relevant Pages

  • Re: How can I scan for named instances of SQL?
    ... The OLE DB Provider for SQL Server 2000 returns instance names using ... SQL-DMO applications can enumerate instances using the SQLServer2 ... Ideally I'd like to add the capability to discover named instances to the ...
    (microsoft.public.sqlserver.security)
  • Re: Is ADO.NET OleDb .NET Data Provider a COM object?
    ... Okay, okay... ... OLE DB is a one-size-fits-all set of providers that can access anything from a relational database to a tuna salad. ... in order to access SQL Server we used OLE DB to access ODBC or SQL Server. ... In a similar way, just because you can connect to MySQL, Paradox, Oracle or FarkleStar databases from an OLE DB or other OSFA provider does not mean your code can interface with these other back-ends. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlServer 2005 Transfer Flame
    ... database between the two servers. ... I do understand your concerns with SQL Server 2005. ... Drag a OLE DB Destination to the panel; ...
    (microsoft.public.sqlserver.dts)
  • Re: a view based on stored procedure
    ... Columnist, SQL Server Professional ... When I execute the stored procedure in Query Analyzer, ... OLE DB error trace [Non-interface error: OLE DB provider unable to process ... In the stored procedure, I am selecting data from 2 views, opening a cursor, ...
    (microsoft.public.sqlserver.programming)
  • Re: Authentication methods for connections to SQL Server in ASP Pa
    ... Microsoft OLE DB Provider for SQL Server error '80004005' ... Multiple-step OLE DB operation generated errors. ... These errors are probably because there is no 'Provider' keyword in your ...
    (microsoft.public.sqlserver.security)