I am getting the following error when trying to preview an RDL report.
- I have full rights to the SQL SERVER
- I have tested my connection to the datasource and it's fine
- I have full rights to the reporting services (serverName/reports)
- My datasource is set to windows authentication
- The event viewer both on the local and remote machines shows nothing
- SQL SERVER logs show nothing
Please note: this report is embedded within an on-premises CRM instance, but I need to update the report.
What am I doing wrong? Any troubleshooting guidance would be most appreciated.