Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

MR allowing only "sa" user?

Posted on by 2,845

I have installed MR in my system. When I open the MR, in credential window it is accepting only sa user and password. If I enter any other users which is in GP it is not allowing. But in another system, I found the MR is allowing both sa and GP users credentials . Please suggest me if anybody know the reason?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MR allowing only "sa" user?

    Hi mani,

    In SQL "ManagementReporter" Database there is a table called "ControlCompany".

    Update the server name in the GLEntityConnectionInformation column. Update the server name in the following string:
    <EntitySetting Name="SQL Server"> <Value xsi:type="xsd:string">server_name</Value> </EntitySetting>

    Reference Link:

    http://support.microsoft.com/kb/2737852

    http://www.azurecurve.co.uk/2013/10/management-reporter-is-unable-to-connect-to-the-company/

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MR allowing only "sa" user?

    Hi Mani,

    Please find the below links that must suits MR user login problem.

    community.dynamics.com/.../64679.aspx

    community.dynamics.com/.../114530.aspx

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans