Discovery Wizhard does not discover my SQL nodes

Discussion:

(too old to reply)

Nitin

2009-04-15 08:22:01 UTC

Hi We have a clustered environment, 4 node active - active cluster. When we
run the discover wizhard, the SQL nodes do not get displayed.It populates the
message stating that the account with which the discovery is being done does
not have administrative privilages on the target machine. The accounts are a
member of the admin group on all nodes.

We are currently running on SQL 2K5, SP2 and SCOM 2007 SP1.The SQL Server's
management pack is also imported.

SCOM is discovering the other SQL instances which are not a part of the
cluster such as the DPM and RMS servers and collecting alerts from these
boxes.

Since we are not able to discover the SQL servers we have manually deployed
the agents on the 4 nodes. Also verified that the respective ports SMB and
445 are open.

The current issue is SCOM is not able to capture the alerts from these
instances and nodes. We are able to see the nodes and the SQL instances
installed on the cluster in the Monitoring --> Computers view without any
issue.

Has anyone come across this issues or knows what's misconfigured ...which is
blocking the alert capturing..

Thanks in advance

Blake Mengotto [MVP]

2009-04-15 20:41:06 UTC

Permalink

Have you imported the latest versions of these management packs? Two new
packs were released recently. Cluster just this past Friday and SQL was a
little bit before that.
--
Regards,
Blake
Email: mengotto<at>hotmail.com
Blog: http//discussitnow.spaces.live.com
OpsMgr MVP

Post by Nitin
Hi We have a clustered environment, 4 node active - active cluster. When we
run the discover wizhard, the SQL nodes do not get displayed.It populates the
message stating that the account with which the discovery is being done does
not have administrative privilages on the target machine. The accounts are a
member of the admin group on all nodes.
We are currently running on SQL 2K5, SP2 and SCOM 2007 SP1.The SQL Server's
management pack is also imported.
SCOM is discovering the other SQL instances which are not a part of the
cluster such as the DPM and RMS servers and collecting alerts from these
boxes.
Since we are not able to discover the SQL servers we have manually deployed
the agents on the 4 nodes. Also verified that the respective ports SMB and
445 are open.
The current issue is SCOM is not able to capture the alerts from these
instances and nodes. We are able to see the nodes and the SQL instances
installed on the cluster in the Monitoring --> Computers view without any
issue.
Has anyone come across this issues or knows what's misconfigured ...which is
blocking the alert capturing..
Thanks in advance

Nitin

2009-04-16 02:09:01 UTC

Permalink

Yes we have imported the latest management packs and tried again but the
result is the same.

The only change done recently was the category of admnistration account of
SCOM was changed from domain - local to domain - global as we were looking
for extending SCOM monitoring acros domains.

Any further areas wehre in we could look into to further drill down the
problem?

thanks in advance..

Post by Blake Mengotto [MVP]
Have you imported the latest versions of these management packs? Two new
packs were released recently. Cluster just this past Friday and SQL was a
little bit before that.
--
Regards,
Blake
Email: mengotto<at>hotmail.com
Blog: http//discussitnow.spaces.live.com
OpsMgr MVP

Blake Mengotto [MVP]

2009-04-16 16:32:34 UTC

Permalink

Sorry, I honestly don't know. I know there was some issue with clusters
with X number of resources, but I thought that was fixed. You might want to
post this in the opsmgr news groups instead of the MOM 2005 newsgrops..

microsoft.public.opsmgr.sql
--
Regards,
Blake
Email: mengotto<at>hotmail.com
Blog: http//discussitnow.spaces.live.com
OpsMgr MVP

Post by Nitin
Yes we have imported the latest management packs and tried again but the
result is the same.
The only change done recently was the category of admnistration account of
SCOM was changed from domain - local to domain - global as we were looking
for extending SCOM monitoring acros domains.
Any further areas wehre in we could look into to further drill down the
problem?
thanks in advance..

Post by Nitin
Hi We have a clustered environment, 4 node active - active cluster.
When
we
run the discover wizhard, the SQL nodes do not get displayed.It
populates
the
message stating that the account with which the discovery is being done does
not have administrative privilages on the target machine. The accounts
are
a
member of the admin group on all nodes.
We are currently running on SQL 2K5, SP2 and SCOM 2007 SP1.The SQL Server's
management pack is also imported.
SCOM is discovering the other SQL instances which are not a part of the
cluster such as the DPM and RMS servers and collecting alerts from these
boxes.
Since we are not able to discover the SQL servers we have manually deployed
the agents on the 4 nodes. Also verified that the respective ports SMB and
445 are open.
The current issue is SCOM is not able to capture the alerts from these
instances and nodes. We are able to see the nodes and the SQL instances
installed on the cluster in the Monitoring --> Computers view without any
issue.
Has anyone come across this issues or knows what's misconfigured
...which
is
blocking the alert capturing..
Thanks in advance