Configure SQL

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.

Right Click Tools with Recast Management Server

To configure SQL in the Recast Management Server interface:

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

2. On the Recast Management Server Settings page, under ConfigMgrServer options, enable the following options:

  • 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}. 

Right Click Tools Standalone

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.