web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Moving Management Repo...
Microsoft Dynamics GP (Archived)

Moving Management Reporters - 'encryption key'

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I move several management reporter to new servers before but not one without the encryption key.   Any suggestions,  the setup was done by someone else.  The key isn't documented.    Any magically encryption key finder or updating/changing key on existing and using the same key on new server ?

Any suggestions is welcome,  Im still pouring through documents to see if I can find the original key

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    26P2ER Profile Picture
    26P2ER 1,775 on at

    Hey Michael  Tsui:

    Have you gone through the below MS community contribution?

    1. https://community.dynamics.com/gp/b/dynamicsgp/archive/2017/07/04/how-to-move-your-management-reporter-2012-database-to-a-new-server

    Best of luck

  • Community Member Profile Picture
    Community Member on at

    yes, I used those instructions many times.. the difference is I had an encryption key prior..  no encryption key this time.

    I tested it via export and import.. but I'm losing all the historical reports... so encryption key is needed

  • Verified answer
    26P2ER Profile Picture
    26P2ER 1,775 on at

    Hi Michael:

    If you have time and a test instance, you may want to try the below tip on how to reset the password for the master key.

    https://dba.stackexchange.com/questions/233040/how-to-change-sql-server-master-key-password/233041

    ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'password';

    I haven't tried this myself but If I had a predicament such as yours, this is the first thing I would try.

    Keep us posted.
    Have you contacted Microsoft?
    Regards

  • Community Member Profile Picture
    Community Member on at

    Sorry for the late response.. end up not carrying over the old reports.   They were not necessary, so using new server with new keys.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans