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 / Finance | Project Operations, Human Resources, ... / Unable to log on to Mi...
Finance | Project Operations, Human Resources, ...
Answered

Unable to log on to Microsoft Dynamics. When Opening SSRS from second AOS/Database

(0) ShareShare
ReportReport
Posted on by CBNestor 44

Hi all,

I have two AOS installed on the same server. 01- for my "Test" and 02- for the "Contoso". My test Business database is working properly with the reports. But on my second instance for the Contoso Database I cannot manage to open any report, the error : Unable to log on to Microsoft Dynamics. shows up.

I tried also attaching the Contoso to the first 01 AOS but the error still persists . even though they have the same Report Server Configuration

I really appreciate your help guys,

thanks a lot!

  • CBNestor Profile Picture
    CBNestor 44 on at
    RE: Unable to log on to Microsoft Dynamics. When Opening SSRS from second AOS/Database

    Thanks Nikolaos. I will probably need it soon, did not I could do that!. Thanks!

  • CBNestor Profile Picture
    CBNestor 44 on at
    RE: Unable to log on to Microsoft Dynamics. When Opening SSRS from second AOS/Database

    Perfect Gunjan . Just What I needed for now. I forgot the second step :)

  • CBNestor Profile Picture
    CBNestor 44 on at
    RE: Unable to log on to Microsoft Dynamics. When Opening SSRS from second AOS/Database

    Hi Nikolaos,

    I understand. But If the SRSS is already pointing my 01-AOS. And I install or attach any database to the 01-AOS should have the functionally of opening the reports because it is already in the right AOS. isnt it correct?

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Unable to log on to Microsoft Dynamics. When Opening SSRS from second AOS/Database

    Yes. Provided you change the following -

    1. Reporting server config in the database from System admin > Setup > Business intelligence > Report servers. Do a "Validate settings" here to confirm.

    2. System service accounts > business connector proxy account  from System admin > Setup > System service accounts. The reporting service needs to have the "Log on" credentials.

    Since you mentioned Contoso database , you won't be able to use the existing accounts as you won't have access to Contoso domain controller. You have to change the account to your domain account.

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,158 Moderator on at
    RE: Unable to log on to Microsoft Dynamics. When Opening SSRS from second AOS/Database

    The SSRS itself is pointing to one AOS at a time. So if you want sometimes to use it with different AX instance / different AOS, you must update configuration in the SSRS side, not only in AX.

    How to create and use that configuration file with SSRS is described here: docs.microsoft.com/.../create-a-new-microsoft-dynamics-ax-configuration

  • CBNestor Profile Picture
    CBNestor 44 on at
    RE: Unable to log on to Microsoft Dynamics. When Opening SSRS from second AOS/Database

    Hi Gunjan,

    Ok but what about if I want to leave only one SRSS attachted to one AOS(01). Any database I connect to the AOS 01 should open the reports. Am I right?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,158 Moderator on at
    RE: Unable to log on to Microsoft Dynamics. When Opening SSRS from second AOS/Database

    Do you have two complete AX instances on the same server? And two instances of Reporting Services?

    If yes, you need to follow this documentation to set it up. It's quite a lot of effort so it's easier if you don't have two SSRS instances on the same server.

    docs.microsoft.com/.../install-multiple-instances-of-reporting-services-on-the-same-computer-for-use-with-microsoft-dynamics-ax

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Unable to log on to Microsoft Dynamics. When Opening SSRS from second AOS/Database

    Hi Nestor,

    You need two different reporting server instances for two AOS servers. You will then need to modify the reporting services config file. Please check here for more details.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,004 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans