BMC Communities: Message List - SQL database instance discovery

Re: SQL database instance discovery

forums@developer.bmc.com — Sat, 22 Nov 2008 00:06:39 GMT

I would bet that if TD has admin access and is performing the right discovery types against a SQL Server system, it would find it.

I would be curious to know how else TD would know about SQL Servers in the environment unless it's using "SqlDataSourceEnumerator.GetDataSources()"

( http://blogs.msdn.com/sushilc/archive/2004/10/14/242395.aspx )

Anyone know that for sure?

Re: SQL database instance discovery

forums@developer.bmc.com — Fri, 21 Nov 2008 16:14:47 GMT

Yes, the LDAP server is correct. The discovery server and the Domain Controller are in the same domain.

And, the user account is a Domain user and is able to login to any system in the domain.

But I noticed that the SQL server and its databases have to be registered in the AD for the discovery servers to find. We registered one database instance in the AD but still couldn't discover it. Trying to investigate further.

Thanks,

Jerry

Re: SQL database instance discovery

petrus.johansson@ikea.com — Thu, 20 Nov 2008 18:21:26 GMT

I noticed that TD not always displays the "actual" error but this is a learning process when reading the logs

That being said, my first questions are:

Can you verify you have specified the LDAP server correct in the discovery task? (if the LDAP is located in another domain than the discovery server you must specify the complete name LDAP.domain.com)

Also, can you verify that the account being used have the appropriate user rights in LDAP?

SQL database instance discovery

forums@developer.bmc.com — Tue, 18 Nov 2008 15:33:21 GMT

Has anyone ever discovered Microsoft SQL server details using topology discovery ? I believe the information should be queried from the LDAP(Active Directory in our case) . We tried using the credentlials for LDAP for one of the DCs while configuring the discovery task, but it doesn't find any database instances. The message shown in the logs - LDAP found 0 CI(s) (Database Inventory)

We have verified that the information about the SQL servers is there in the AD

Thanks,

Jerry