Jasper Report Server install using MSSQL external database - User does not have the correct privilege

Products

• CA Identity Suite

Issue/Introduction

I am doing an install of Jasper Server 7.1.1 and I am on the screen to enter credentials and get the following message:

 

User does not have the correct privilege

 

What permissions are necessary to have on the database to perform the installation?

 

 

 

Resolution

Add the sysadmin role to the MSSQL Jasper reporting database user.