Discovery Wizard Hangs while trying to discovery a machine.

Summary

After you have added a machine name to the running version of the screen below and click next and discover, the discovery wizard hangs.

Causes

Causes include:

o   DTC Service is not running:

o   SQL Server Broker is not activated.

o   The Run As Action Account is not correct.

 Resolution

Do one or more of the following:

1. Go to start then to Administrative Tools. Select Service Manager

The above image is the result of going from the general view to the Application server view. The two DTC services are not running.  Click on the service and click on the run button.  Close down the console and Go to Start, Administrative Tools and click on services:

Stop System Center Data Access. Stop System Center Management. Restart System Center Data Access. Restart System Center Management.

Try to ping the box using the Command Prompt with Run As Administrator rights. If this works, bring up System Center Management Console. And try discovering the same computer.

If the discovery still hangs, go to Start, Select All Programs and expand SQL Serve r 2008 R2:

Click on the SQL Server Management Studio console and connect to SQL Server once the console is up. Once connected, expand the database view to expose OperationsManager. Highlight OperationsManager and right click on it. Go to properties and click on it.

By default, the first screen visible will be General and this is where you can view the owner of the database.  If you need to change it, later on, you can by highlighting the OperationsManager database, click on new query and type in:
sp_changedbowner 'new owner goes here'
Then click on the “! Execute” tooltip button below the menus.
On the left side where General is highlighted, move your mouse down to Options and click it. Scroll down to the Service Broker. Below it should be Broker Enabled and it should be set to true.  If it isn’t, click inside the false and a dropdown will allow you to set it to true. The image below will show you what this looks like.

Go to Start, Administrative Tools and click on services. Find SQL Server (MSSQLSERVER) . Stop and Start the service.

Stop System Center Data Access. Stop System Center Management. Restart System Center Data Access. Restart System Center Management.

Bring up System Center Operations Manager and try discovering the machine.