The AppManager setup program installs the Control Center Configuration Checker utility with the Control Center and Deployment services. Use the utility to test Microsoft DTC connectivity between the CCDB and the QDBs it manages and to validate your Deployment services installation. For more information about testing Microsoft DTC connectivity, see Verifying Microsoft DTC Connectivity. For more information about validating your Deployment services installation, see Validating Deployment Services Installation.
Control Center uses the Microsoft DTC to connect to every QDB it manages. The DTC must run as a service on the computer where you install the CCDB. To ensure Control Center can find and use DTC, you might need to change some security settings. For more information about the recommended security settings, see Configuring DTC Security Settings.
Run the Control Center Configuration Checker utility for each QDB you plan to manage with Control Center.
To check DTC connectivity between the CCDB and QDBs:
Ensure Microsoft .NET Framework 3.5 Service Pack 1 is installed.
On the Configuration Check window of the Control Center setup program, click Run.
Provide the following information and click OK:
Name of the SQL Server and, if applicable, instance that hosts the CCDB for which you are testing connectivity
Name of the CCDB for which you are testing connectivity
Name of the SQL Server and, if applicable, instance that hosts the QDB for which you are testing connectivity
The Configuration Checker utility runs tests in the Preinstall category to verify that DTC connectivity exists between the CCDB and QDB and check the validity of the SQL Server names.
To run the utility for another QDB, select Tasks > Server Setup.
For more information about resolving issues with DTC connectivity, see Troubleshooting DTC Connectivity.
This section describes how to configure the DTC security settings to ensure Control Center can find and use DTC. If you use clustered servers for the CCDB, complete the task for each cluster node.
If DTC communications must pass through a firewall, you might need to reconfigure DTC to work through the firewall after changing the security configuration. For information about reconfiguring DTC to work through a firewall, see http://support.microsoft.com/kb/311846.
To configure the DTC security settings:
In the Component Services application in Administrative Tools, expand Component Services and then expand Computers.
Expand My Computer and then expand Distributed Transaction Coordinator.
Right-click Local DTC and select Properties.
On the Security tab, select the following items:
Network DTC Access
Allow Remote Clients
Allow Remote Administration
Allow Inbound
Allow Outbound
No Authentication Required
Enable XA Transactions
Restart the computer.
This section describes common DTC issues. If this section does not describe the DTC issue you experience, you might want to review the following Microsoft Knowledge Base articles:
http://support.microsoft.com/kb/306843
This article describes how to troubleshoot DTC firewall issues.
http://support.microsoft.com/kb/306212
This article describes how to troubleshoot an error that occurs when you use a linked server in Microsoft SQL Server.
http://support.microsoft.com/kb/293799
This article describes how to use the DTCTester tool to test a distributed transaction against a SQL Server.
The following table lists common DTC issues and provides references to information about resolving the issues.
|
Issue |
Reference |
|---|---|
|
Server name resolution failure |
|
|
SID of one of the DTCs is not unique |
|
|
SQL Server system variable @@servername is incorrect or null |
|
|
Double hop error with Kerberos credentials |
Configuring Kerberos Delegation for a Distributed Control Center Environment |
The Control Center Configuration Checker utility includes tests that validate proper configuration of the Deployment services. The following table describes the test categories.
|
Tests in this category... |
Check... |
|---|---|
|
Remote Deployment Service |
Whether the Deployment Service is available and properly configured to remotely deploy agents and monitoring modules |
|
Remote Deployment Web Service |
Whether the Deployment Web Service is available and properly configured to remotely deploy agents and monitoring modules |
|
Proxy Remote Deployment Web Service |
If the Deployment Service must run in proxy mode to access the CCDB because of firewalls, proper SSL configuration |
To validate Control Center and Deployment services installation:
Start the AppManager Control Center Configuration Checker in the AppManager program folder.
On the Tasks menu, select Remote Deployment Setup.
Provide the following information and click OK:
Name of the computer where you installed the Deployment Service.
(Conditional) If the Deployment Service is on a remote computer, also provide credentials to connect to the computer.
Name of the computer where you installed the Deployment Web Service.
(Conditional) If the Deployment Web Service is on a remote computer, also provide credentials to connect to the computer.
(Conditional) If the Deployment Service must run in proxy mode to access the CCDB, name of the computer where you installed the proxy Deployment Web Service and credentials to connect to the remote computer.
Name of the SQL Server and instance that hosts the CCDB.
Name of the CCDB.
Select the category that includes the tests you want to run and click Run.
The utility runs each test included in the selected category. View the results of each test on the Test Result tab.