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

Article ID: 969204 - View products that this article applies to.
Expand all | Collapse all

On This Page

Source: Microsoft Support

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.

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.

Cause

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

Resolution



Adjust the Group Policy Object (GPO) to accept 8 characters:
  1. 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.
  2. 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.
  3. 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”.
  4. Move server’s computer object back to OU it previously belonged to (with the proper Minimum Password Length policy), and reboot.
  5. 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.
  6. Run reports in the MDM Reporting Services Console to ensure that reports work.

More Information

This issue applies to:



SCMDM 2008 Resource Kit Tools
SCMDM 2008 Resource Kit Tools SP1

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.

Properties

Article ID: 969204 - Last Review: March 18, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft System Center Mobile Device Manager 2008
Keywords: 
kbrapidpub kbnomt KB969204

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com