When try to configure MR 2012 CU8, with no installation before for MR.
faced with following error massage
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
thanks for respond
*This post is locked for comments
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
Also try to give the eight letters password or bypass the encrypt password field if no error popsup.
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)
In Database Configuration section, mark the check box "Use Windows authentication" and try again it will resolve your problem.
Hope this helps!!!
Can you try with the same "sa" username and password for Database configuration too.
Hi Mounir,
As Rudra mentioned, please check the Database Configuartion & Service Account credentials are correct.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156