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)