SQL Configuration

Configuring your Recast tools to query the ConfigMgr SQL database directly for some actions can speed up actions and help with WMI quota violations. Configuring your tools to access your MBAM Recovery and Hardware database to query RecoveryKeyIDs will help with the MBAM Dashboards and with the Security Tools management of BitLocker keys. These SQL options offer enhanced performance for larger environments and for large datasets.

The method you'll follow for SQL configuration depends on whether you're using Right Click Tools Enterprise with Recast Management Server or in Standalone mode.

To configure SQL in the Recast Management Server interface:

1. In your Recast Management Server, navigate to Settings > Settings

2. Under ConfigMgrServer options, configure the following settings:

  • SQLServer: To enable Right Click Tools to query SQL directly, enter the FQDN of the server hosting the CM SQL database. 
  • SQLDatabase: To enable Right Click Tools to query SQL directly, enter the name of the CM Database, usually CM_{SiteCode}. 

To configure SQL in the Configure Recast RCT application:

1. From the Windows Start menu, open the Configure Recast RCT application.

NOTE: You can also access Configure Recast RCT from your Configuration Manager console by navigating to the Recast Software node and selecting Configure Recast in the 'How Can We Help?' section.

2. On the SQL Configuration tab, enter the SQL Server and SQL Database information for your ConfigMgr Server.

3. Enter the MBAM information in the lower half of the window. 

NOTE: If you use ConfigMgr or AD to store your BitLocker keys, you do not need to complete the MBAM section.