Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

MR 2012 configure error message.

Posted on by Microsoft Employee

When try to configure MR 2012 CU8, with no installation before for MR.

faced with following error massage

1423.configure-report.jpg

8473.Configure-Phase-01.jpg

so i was trying to delete old MR database and begin a new configure, but the same msg appears

FYI

"mr" user : has administrator rights in domain and also sysadmin in SQL Server

the password it is the same for all users

followed configure entry

2844.Configure-Phase-02.jpg

8203.SQL-Users.jpg

thanks for respond

 

*This post is locked for comments

  • Suggested answer
    rudra Profile Picture
    rudra 6,534 on at
    RE: MR 2012 configure error message.

    Previous database configuration has been solved and now this master key encryption error coming right?

    Please try the below link to regenerate the master key:-

    technet.microsoft.com/.../ms187788.aspx

    social.technet.microsoft.com/.../getting-msg-15466-level-16-state-2-line-1-an-error-occurred-during-decryption-while-executing-a

    Also try to give the eight letters password or  bypass the encrypt password field if no error popsup.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MR 2012 configure error message.

    the domain administrators can access sql windows authentication with no error MSG, so i used administrator as account to configure MR, administrator has sysadmin rights in sql server

    when get the error log file found

    .Net SqlClient Data Provider: Msg 15466, Level 16, State 2, Line 1 An error occurred during decryption.

    Is there any suggestions?


    Thanks

    Mounir

    and the whole file

    4/11/2014 10:16:58 PM - Displaying user object picker for user account selection.
    4/11/2014 10:17:37 PM - Validating user administrator, domain FG, and password.
    4/11/2014 10:17:37 PM - Checking whether database ManagementReporter1000 exists
    4/11/2014 10:17:37 PM - Checking whether current user has SQL role sysadmin
    4/11/2014 10:17:37 PM - Checking SQL Server version; result: 10.50.1600.1
    4/11/2014 10:17:37 PM - Validating password against password policy for computer PG
    4/11/2014 10:17:37 PM - Validating user administrator, domain FG, and password.
    4/11/2014 10:17:37 PM - Checking port 4712 against ports with active TCP listeners.
    4/11/2014 10:17:37 PM - Validating user administrator, domain FG, and password.
    4/11/2014 10:17:37 PM - Checking whether database ManagementReporter1000 exists
    4/11/2014 10:17:37 PM - Checking SQL Server version; result: 10.50.1600.1
    4/11/2014 10:17:38 PM - Starting deployment of Management Reporter 2012 Application Service
    4/11/2014 10:17:38 PM - Creating PrincipalContext for domain FG
    4/11/2014 10:17:38 PM - Finding Principal for user administrator in context for domain FG
    4/11/2014 10:17:38 PM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\ManagementReporter.dacpac
    4/11/2014 10:17:38 PM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\SchedulerStore.dacpac
    4/11/2014 10:17:38 PM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\ConnectorStore.dacpac
    4/11/2014 10:17:38 PM - Deployment parameters:
    DatabaseCollation: SQL_Latin1_General_CP1_CI_AS
    WindowsLoginToCreate: FG\administrator
    FirstAdminUserName: FG\administrator
    FirstAdminSid: S-1-5-21-3821395670-2128332639-1314909535-500
    FirstAdminDisplayName: Administrator

    4/11/2014 10:17:38 PM - Extracting supporting files for database deployment...
    4/11/2014 10:17:38 PM - Beginning database deployment...
    4/11/2014 10:17:38 PM - Initializing deployment (Start)
    4/11/2014 10:17:42 PM - Initializing deployment (Complete)
    4/11/2014 10:17:42 PM - Analyzing deployment plan (Start)
    4/11/2014 10:17:42 PM - Analyzing deployment plan (Complete)
    4/11/2014 10:17:42 PM - Updating database (Start)
    4/11/2014 10:17:42 PM - Creating ManagementReporter1000...
    4/11/2014 10:17:42 PM - Creating [FILES]...
    4/11/2014 10:17:42 PM - Updating Collation
    4/11/2014 10:17:42 PM - Creating [GeneralUser]...
    4/11/2014 10:17:42 PM - Creating [Connector]...
    4/11/2014 10:17:42 PM - Creating [Scheduling]...
    4/11/2014 10:17:42 PM - Creating Master Key...
    4/11/2014 10:17:42 PM - .Net SqlClient Data Provider: Msg 15466, Level 16, State 2, Line 1 An error occurred during decryption.
    4/11/2014 10:17:42 PM - Script execution error. The executed script:
    CREATE MASTER KEY ENCRYPTION BY PASSWORD= N'$(DatabaseMasterKey)';


    4/11/2014 10:17:42 PM - An error occurred while the batch was being executed.
    4/11/2014 10:17:42 PM - Updating database (Failed)
    4/11/2014 10:17:42 PM - The database deployment failed. Additional information: Could not deploy package.
    Error SQL72014: .Net SqlClient Data Provider: Msg 15466, Level 16, State 2, Line 1 An error occurred during decryption.
    Error SQL72045: Script execution error. The executed script:
    CREATE MASTER KEY ENCRYPTION BY PASSWORD= N'$(DatabaseMasterKey)';

    4/11/2014 10:17:48 PM - Microsoft.Dynamics.Performance.Deployment.Console.Core.DeploymentFailedException: An error occurred during database deployment. View the deployment log for more information.
    at Microsoft.Dynamics.Performance.Deployment.Reporting.ReportingDatabase.DeployDatabasePackages(String connectionString, String databaseName, Dictionary`2 parameters)
    at Microsoft.Dynamics.Performance.Deployment.Reporting.ApplicationServiceDeploymentPart.DeployWithSettings(IDictionary`2 settingsToDeployWith)
    at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.DeploymentViewModel.TryRemoveFromView(Boolean isProgressing)


  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: MR 2012 configure error message.

    In Database Configuration section, mark the check box "Use Windows authentication" and try again it will resolve your problem.

    Hope this helps!!!

  • Suggested answer
    rudra Profile Picture
    rudra 6,534 on at
    RE: MR 2012 configure error message.

    Can you try with the same "sa" username and password for Database configuration too.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MR 2012 configure error message.

    Hi Mounir,

    As Rudra mentioned, please check the Database Configuartion & Service Account credentials are correct.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MR 2012 configure error message.

    Rura  .. thanks you reply

    unfortunately, the same massage appear, even if login with mr.

    about mention database server i think it is right, because if wrong MR2012 can not select Dynamics DB from dynamics GP connection information Section - last section.

    thanks

    FYI

    FG Domain controller

    PG SQL Server

  • Suggested answer
    rudra Profile Picture
    rudra 6,534 on at
    RE: MR 2012 configure error message.

    Hi ,

    Please login to the server with the username MR and then configure this setups and in the Database configuration please mention the correct database server name and credentials and in the above screenshot i found in the database configuration you didt mention domain name infront of ur username MR eg: FR\mr or use can select the check box windows authentication and try it will work for sure.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans