Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter 20...
Microsoft Dynamics GP (Archived)

Management Reporter 2012 CU16 Install errors

(0) ShareShare
ReportReport
Posted on by mattvs

Hi,

Im having trouble configuring MMR 2012 CU16 with a Legacy GP database. I am installing in the following environment:

Server = Windows server 2012 R2

SQL Server = 2014

GP = 2016R2

.Net = 4.7

Service accounts = Domain Admin 

Database account = SA

All other sys requirements have been check and installed.

The first error in the log is:

"There was no endpoint listening at servername.fqdn/CompanyService.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details."

2nd error:

"Net SqlClient Data Provider: Msg 33094, Level 16, State 9, Line 1 An error occurred during Service Master Key decryption
Machine: ServerName"

3rd Error:

An error occurred while the batch was being executed.
Machine: ServerName
05/01/2018 13:53:55 - Updating database (Failed)
Machine: ServerName
05/01/2018 13:53:55 - The database deployment failed. Additional information: Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package.
Error SQL72014: .Net SqlClient Data Provider: Msg 33094, Level 16, State 9, Line 1 An error occurred during Service Master Key decryption
Error SQL72045: Script execution error. The executed script:
CREATE MASTER KEY ENCRYPTION BY PASSWORD= '******';

Has anyone got any ideas?? I can't figure out what is missing?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter 2012 CU16 Install errors

    I am glad to hear you got it working and thanks for providing the steps that ultimately resolved the issue. Have a good weekend!

  • Verified answer
    mattvs Profile Picture
    mattvs on at
    RE: Management Reporter 2012 CU16 Install errors

    Thanks again both for pointing me in the right direction. Here is what i did to resolve the issue

    Jake - The select script you provided return no results so I knew there wasn't any old keys and safe to regenerate the key.

    A force regenerate wouldn't work as there was no key to decrypt so we used the following script.

    ALTER SERVICE MASTER KEY REGENERATE

    After some investigation it appears that the original SQL installation was completed using network accounts, which was later changed to Domain Service accounts.

    The MR install worked perfectly after updating SQL.

    Thanks again!

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter 2012 CU16 Install errors

    KB2744330 is the same script as the blog I linked to. Since he is trying to deploy a new MR database, I wonder if the master key in SQL is corrupt. Check and see if any SQL databases are encrypted:

    Use master

    go

    select * from sys.databases

    where is_master_key_encrypted_by_server = 1

    or  is_encrypted = 1

    If databases are encrypted, you would want to check with that software if it is okay to reset the master key before proceeding. If nothing is encrypted, it is safe to re-create the service master key in SQL:

    Use master;

    Go

    ALTER SERVICE MASTER KEY FORCE REGENERATE;

    Go

    Once the master key is re-created, try the MR deployment again.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Management Reporter 2012 CU16 Install errors

    Hi Matt,

    No there is no references of past MR setups in the DYNAMICS DB AFAIK..

    I never encountered this kind of  error message, but looking at the message, I'd guess that you may have to provide a password for the database encryption, which seems to be missing right now.

    Have a look at the KB2744330 from Microsoft on how to fix this problem. There is a script provided that will allow you to set / reset  the encryption password for the MR 2012 DB.

    At some point during the setup of a new MR database, you're supposed to provide a password for the DB encryption... did you do that ?

  • mattvs Profile Picture
    mattvs on at
    RE: Management Reporter 2012 CU16 Install errors

    Thanks Both

    I doubled checked the old server and there is no MR database, is there any information held in the Dynamics DB that might be causing the issue? Just in case an old version of MR was installed on the old server and was then removed?

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Management Reporter 2012 CU16 Install errors

    Jake,

    I would agree if that setup was an upgrade of an existing MR Database.. but Matt said that it was a brand new installation and that MR hasn't existed before.. It was my first thought too, and that's why I asked what kind of setup this was..

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter 2012 CU16 Install errors

    The Service Master Key decryption error is typically caused by moving or restoring the MR SQL database. Run the script from the following blog against the MR SQL database and then try deploying the services and integration again:

    community.dynamics.com/.../how-to-move-your-management-reporter-2012-database-to-a-new-server

  • mattvs Profile Picture
    mattvs on at
    RE: Management Reporter 2012 CU16 Install errors

    Thank for the reply.

    It's a fresh install on a brand new Server. GP was recently moved to a new server Management Reporter didn't exist on the old server.

    I agree with the admin account, i'm just trying to rule out any permission issues at the moment.

    I have installed MMR a few times before and have never come across an issue like this.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Management Reporter 2012 CU16 Install errors

    Hi Matt,

    is this a fresh installation of MR2012 or do you attempt to upgrade an existing release that already has a database configured ?

    BTW, it is not recommended to use a domain admin account to run the MR Services.. a simple dedicated domain user acct will do the job.. all you have to make sure is that the pwd never expires and that the account has proper access to the SQL server.

    If you follow the setup instructions of the MR 2012 guide, it is pretty straight forward.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans