3,024
When i want to run any report of dynamics ax 2012 R3, It shows the below error please help:
"Error while setting server report parameters. Error message: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)"
Thanks and Regards,
Shabir Ahmad
*This post is locked for comments
You have to grant your users the required rights in SSRS as well. Everyone who should be able to print reports must be associated with DynamicsAXBrowser role in SSRS. Usually it's easiest to have one AD group for AX users and grant this DynamicsAXBrowser right to the AD group. Also make sure that this setting is applied to the entire report folder, not only individual reports.
First thanks to all members for your prompt response:
Dear Nikolaos Mäenpää ,
Your first link was great, we resolved that issue by The connection to the report server database is managed through the Reporting Services Configuration tool, as it was referenced in your that link. , so now we can print report from our Administrator User accounts and from client users Id dynamics standerds reports can be run like vendors, customers, but our company customized reports are not running giving error. Even our users have proper rights in Report Server URL and Folder.For example after making GRN a report will be created that is not showing .Further, our purchase order report and sales invoice is not showing and throwing same error please watch here."Error while setting server report parameters. Error message granted user'Domain Name\User Name' are insufficient performing this operation(rsAccessDenied)"
Again on Administrator user Id we can run all reports but on clients side this is the issue
One thing more, Administrator User Account is accessing for example "ABC"AOS and from clients i check it is "xyz" AOS as example.
Thanks and regards,
Shabir Ahmad
Follow these steps to diagnose the problem
> Report service running?
> Report Databases exist and multi user mode on?
> Your user have proper rights in Report Server URL and Folder?
> Firewalls are disabled?
> Named IP enabled?
> Any network restriction between AX and SSRS server?
One possible explanation is that the report server database has been deleted. Did you try all the things that were suggested in the documentation? If not, please do. Did you notice that there is an entire chapter for troubleshooting this error message that you have.
Dear Nikolaos Mäenpää ,
Does it mean that reports server has been deleted?? if deleted what should i do, please suggest me
Thanks and regards,
Hi, please check if this troubleshooting documentation helps: docs.microsoft.com/.../ms156468(v=sql.105)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (