BMC Communities Banner
Up to Discussions in Discovery

This Question is Possibly Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (5 pts)
3 Replies Last post: Nov 21, 2008 6:06 PM by brian.luke@schwab.com  
jerryjoy Enthusiast
jerryjoy
28 posts since
Dec 4, 2007
Currently Being Moderated

Nov 18, 2008 9:33 AM

SQL database instance discovery

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

Petrus Johansson HotShot
Petrus Johansson
260 posts since
Sep 30, 2008
Currently Being Moderated
1. Nov 20, 2008 12:21 PM in response to: jerryjoy
Re: SQL database instance discovery

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?

Report Abuse
jerryjoy Enthusiast
jerryjoy
28 posts since
Dec 4, 2007
Currently Being Moderated
2. Nov 21, 2008 10:14 AM in response to: Petrus Johansson
Re: SQL database instance discovery

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

Report Abuse
brian.luke@schwab.com Enthusiast
brian.luke@schwab.com
15 posts since
Aug 14, 2007
Currently Being Moderated
3. Nov 21, 2008 6:06 PM in response to: jerryjoy
Re: SQL database instance discovery

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?

Report Abuse

More Like This

  • Retrieving data ...