Select the product you need help with

Error message when installing MDM Reporting Services from the SCMDM 2008 Resource Kit Tools

Article ID: 969204 - View products that this article applies to.

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

Back to the top | Give Feedback

Symptom

During the installation of MDM Reporting Services, you will find the following errors messages:

Type: Error
Source: MsiInstaller
Event ID: 10005
Description:
Product: Microsoft Mobile Device Management Reporting -- Error 26204. Error -2147217900: failed to execute SQL string, error detail: Please create a master key in the database or open the master key in the session before performing this operation., SQL key: CreateDBWindows SQL string: IF EXISTS (SELECT * FROM sys.certificates where name = 'MDMRPTCert')
Drop CERTIFICATE MDMRPTCert
If Exists (SELECT * FROM sys.symmetric_keys)
Drop Master Key
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'YonaRPT9';
CREATE CERTIFICATE MDMRPTCert
WITH SUBJECT = 'MDM Reporting ',
EXPIRY_DATE = '12/31/2020';
--##################################Case insensitive
ALTER DATABASE MDMRPTWH COLLATE SQL_Latin1_General_CP1_CI_AS
--##################################### BEGIN : TABLE CREATION SCRIPTS ############################
/****** Object: Table [dbo].[InventoryCategory] Script Date: 12/09/2007 16:20:37 ******/
SET ANSI_NULLS ON

MDMSetup[YYYY_MM_DD].log:

System.Date.SqlClient.SqlException: Password validation failed. The password does not meet Windows policy requirements because it is too short.

Back to the top | Give Feedback

Cause

SQL script is failing due to MDM master key encryption password 'YonaRPT9' not meeting the GPO password complexity requirement.

Back to the top | Give Feedback

Resolution

Adjust the Group Policy Object (GPO) to accept 8 characters:

Bypass Minimum Password Length Policy and Install MDM Reporting Services:

a. Create new OU.
b. Create and link a new GPO the new OU.
c. Define the Minimum Password Length policy so that the password must be at least 8 characters.
d. Move the computer account object for the server where SCMDM Reporting Services installation is failing (password being too short), into the new OU and reboot the server.
e. After reboot, install SCMDM Reporting Services.
Generate a new master key using a password that meets the Minimum Password Length policy criteria:

a. Open SQL Server Management Studio, expand the Databases node.
b. Right-click on the "MDMRPTWH" database, and select New Query.
c. Type in the following command:

ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = '<strong password here>'

d. Execute the command.
Launch the SCMDM Reporting Admin Utility, and enter to configure the credentials used to connect to the SCMDM database server, and SCMDM Gateway server. This step encrypts the credentials using the master key created in the previous step. Detailed steps for configuring the Admin Utility are included in the self-extracting executable for SCMDM Reporting Services installation documentation. See section “Initial Setup of the ETL Scripts”.
Move server’s computer object back to OU it previously belonged to (with the proper Minimum Password Length policy), and reboot.
After reboot, run open SQL Server Management Studio and run the MDMRPTSSISJob to verify report pulling works. See section "Process the Initial Set of Data" in the SCMDM Reporting Services installation documentation.
Run reports in the MDM Reporting Services Console to ensure that reports work.

Back to the top | Give Feedback

More Information

This issue applies to:

SCMDM 2008 Resource Kit Tools
SCMDM 2008 Resource Kit Tools SP1

Back to the top | Give Feedback

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

Back to the top | Give Feedback