Overview
In this section we will discover some issues with the JasperServer
Data Source
When creating a user for the Data source (ex. jasperreporting) feel free to give the following roles for SQL Server:
- db_datareader
- “GRANT VIEW DATABASE STATE TO user;
Otherwise, you will have a problem when you try editing the domains.
Allow non-admin users to change Passwords
By default, non-admin users cannot change their passwords. To allow that, edit the following
Edit param file
<property name="allowUserPasswordChange" value="false"/> <!--note: if passwordExpirationInDays is positive, it will overwrite the above allowUserPasswordChange and the password changing UI will be displayed--> <property name="passwordExpirationInDays" value="0"/>
In /WEB-INF/jasperserver-servlet.xml