Difference between revisions of "Zero Reports Available"
| Line 17: | Line 17: | ||
<li><strong>SSRS Reports Service Password</strong></li> | <li><strong>SSRS Reports Service Password</strong></li> | ||
</ul> | </ul> | ||
These details represent a domain user account. It may be the case that the account has been disabled, the password has expired or been changed, or the account is otherwise not in good order. IT should be able to reactivate the account for you, and ideally make changes so that the password doesn't expire. In the event that a new password is associated with the user account, make sure to apply it back to the <strong>SSRS Reports Service Password</strong> setting. | These details represent a domain user account. It may be the case that the account has been disabled, the password has expired or been changed, or the account is otherwise not in good order. IT should be able to reactivate the account for you, and ideally make changes so that the password doesn't expire. | ||
<br> | |||
In the event that a new password is associated with the user account, make sure to apply it back to the <strong>SSRS Reports Service Password</strong> setting. | |||
<br> | <br> | ||
Sometimes, a reactivated account will need to be manually logged in to a PC at least once to bring it back into good order.</li> | Sometimes, a reactivated account will need to be manually logged in to a PC at least once to bring it back into good order.</li> | ||
Revision as of 13:17, 28 March 2023
PTS 5 makes use of a domain service account to run reports. If the account has been disabled or the password expired, PTS will no longer be able to access the reports with the saved credentials, and the problem manifests as there being no report documents available to select from.
Symptoms
On the reports screen, you will be able to search and filter your prescription sample but you will not be able to select a report type, and the tab will read "Reports (0)".
Cause
- The service account that was setup for this purpose has either been disabled, or the password has expired or been changed
- On the SSRS server, the "SQL Server Reporting Services" Windows service has been stopped, disabled, or set to manual start type
- If the server is using SSL, the certificate details may be invalid
Solution
-
Go to Applications Settings and make a note of the user details stored in the following settings:
- SSRS Reports Service User
- SSRS Reports Service Password
These details represent a domain user account. It may be the case that the account has been disabled, the password has expired or been changed, or the account is otherwise not in good order. IT should be able to reactivate the account for you, and ideally make changes so that the password doesn't expire.
Sometimes, a reactivated account will need to be manually logged in to a PC at least once to bring it back into good order.
In the event that a new password is associated with the user account, make sure to apply it back to the SSRS Reports Service Password setting.
- Log in to the SSRS server and make sure the "SQL Server Reporting Services" Windows service is started and is set to start automatically. You can identify the name of your SSRS server via the "URL of SQL Reports Server" setting in Application Settings in PTS.
- In SQL Reporting Services Configuration Manager, go to the Web Service URL tab and verify that a current, working SSL certificate is selected in the certificate dropdown.