Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter

(0) ShareShare
ReportReport
Posted on by

I have installed Management Reporter on the server and the application pool nor the website have been created.  I have the proper permissions.  Has anyone seen this before?  Thanks

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Management Reporter

    Hi  Ian,

    I Have a two companies 

    Company A --- Functional Currency -- USD

         Transaction Currency - UK

    Company B -- Functional Currency - UK

       Transaction Currency - USD

    We have create a exchange rate for UK in company A and given the access permission to Company B, Does these exchange rates how reflects in Company B. How the GL and end of the year closing effect. 

    How the balance sheet works in this scenario. 

    Please provide some solution on this. 

    Thanks,

    Srinivas

  • Community Member Profile Picture
    on at
    RE: Management Reporter

    I got passed it.  I reset the password in GP and it worked.   Now I am getting this error:

    Data mart connection information: The Management Reporter data mart database requires SQL Server 2008 (10.0.1600.22) or later. The version of the specified server is 10.0.1600.22.

    The version of SQL I have is:  10.0.2531.0 which is later than 10.0.1600.22

  • Community Member Profile Picture
    on at
    RE: Management Reporter

    So I looked at the SQL log and got an error that logon failed: Password did not match.  I am copying and pasteing in the password so not sure why it is not working.  I am able to sign into GP using this user.  

  • Community Member Profile Picture
    on at
    RE: Management Reporter

    The server has not changed name and the server name is correct.  

  • Ian Grieve Profile Picture
    22,784 on at
    RE: Management Reporter

    Has someone renamed your SQL Server? If so that could cause problems for the upgrade of Dynamics GP.

    What does <em>select @@SERVERNAME</em> return?

  • Community Member Profile Picture
    on at
    RE: Management Reporter

    One thing I noticed is that in the SQL Server name it has S_GP_PROD, but in the console under Database connection it says SGP_PROD.   I typed in the right name and even copy and  pasted the name in, but it is not taking.  I have a feeling that is a problem, but not sure what to do.  The Management Reporter database is created under the server with the name S_GP_PROD.  

  • Community Member Profile Picture
    on at
    RE: Management Reporter

    I did try that first.  Doesn't matter which user I use.  

  • Ian Grieve Profile Picture
    22,784 on at
    RE: Management Reporter

    Could you try the sa account? (Copy and paste the password to avoid the bug I mentioned).

  • Community Member Profile Picture
    on at
    RE: Management Reporter

    Windows user, the user has access to sQL server and is the owner of the Mangement reporter db

  • Ian Grieve Profile Picture
    22,784 on at
    RE: Management Reporter

    OK, there was a bug in one of the earlier versions where the password was validated as you typed each character.

    Are you using WIndows auth or a SQL user? If a SQL user, is your user locked out?

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans