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 AX (Archived) / Connect to a Sql serve...
Microsoft Dynamics AX (Archived)

Connect to a Sql server database during installing Reporting Services extensions ?

(0) ShareShare
ReportReport
Posted on by San Artham 3,175

Hi All , I see this screen while installing Reporting Services Extensions for AX 2012 R3.

Connect to a Sql server database  - what do I fill in for Database ?  Is it AX Transactional DB or ReportServer DB ?

Here is the screen-shot

Thanks for your help,

San

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    It should be AX Transactional DB

    Please verify and update us with your findings

  • San Artham Profile Picture
    San Artham 3,175 on at

    thank you Nitesh, I just verified this one. But after installing Reporting Services Extensions I am getting this error if I try to access any report from AX client:

    Error while setting server report parameters. Error message: The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)

    If I try to access any report from IE directly then I get this error:

    The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)

    Log on failed. Ensure the user name and password are correct. (rsLogonFailed)

    Logon failure: the user has not been granted the requested logon type at this computer

    User is admin role in AX and has got all the roles on Report Server (Browser, Content Manager, DynamicsAXBrowser, My Reports, Publisher, Report Builder).

    Any help is great

    Thanks,

    San

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Execution account of SSRS reporting services and Business connector account should be same

    I suspect these two accounts are not set properly

    Please verify and update us with your findings

  • San Artham Profile Picture
    San Artham 3,175 on at

    BCProxy and SSRS account were both same for sure. This worked for me:

    from this link I understood that BC proxy account needs Allow log on locally rights in Local Security Policy> Local Policies> User Rights Assignment.

    For some reason this was disabled for me in this VM (may be because it was AD too), so I just gave BC proxy account domain admin and Admin rights. This resolved the issue

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 AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans