Options
Reports - database doesn't seem to be valid Reporting Database
Johanna
Member IT Monkey ✭
Hi!
I've just set up my portal and bumps into an issue with the Reports. I get this message:
My reports works fine from SCCM and webbrowser.
Any suggestions?
I've just set up my portal and bumps into an issue with the Reports. I get this message:
My reports works fine from SCCM and webbrowser.
Any suggestions?
0
Best Answer
-
Options
wally_mead
Member Advanced IT Monkey ✭✭✭
I think your issue is the top setting. You should use the Report Server URL, not the Report Manager URL. Try http://server/reportserver5
Answers
Make sure your "SCCMCireson" SQL account has at least dbDataReader permissions to the ReportServer database.
To verify this, log in to the SQL Server Management Studio, go to Security -> Logins -> SCCMCireson, right click and select Properties.
On the left, select User Mapping. Select the ReportServer database and make sure db_datareader is checked.
We use that connection to list available reports for you to choose from when setting up which reports you want to be available from the portal.
Once assigned to the portal, we use a report viewer to run the reports, that is why we require both the url to the reporting server and the SQL connection.
Let me know if that works.
Best regards
Flemming Appelon Christiansen
Hi,
Thanks for quick answer!
Unfortunately that was not it. The account has the db_datareader checked for that database
Does the SQL server have SQL Authentication enabled?
Select Properties for the SQL Server and select Security from the left and see if Server authentication is set to SQL Server and Windows Authentication.
Can you login to SQL Server Management Studio with that account and access the Reports database?
Best regards
Flemming Appelon Christiansen
That was it!
Changed the URL to http://servername/reportserver and it works now.
Thanks to both of you for the help!