Information - Online Enrollment - Reapplying Permissions : Aeries Software

Kevin Praeger

started a topic almost 4 years ago

For self-hosted customers running Aeries Online Enrollment, after applying the 5/31/2019 or later version of Aeries, database structure changes will likely require re-applying permissions to the AIRRole in SQL. Follow the instructions in this Document to ensure your Online Enrollment instance has all needed permissions.

C

Chad Swaim

said almost 4 years ago

I was told these SQL commands were ran and received a successful after the update was applied. Should we re run the update after running these SQL commands? Running the SQL commands did not fix it is why I ask.

Thanks,

Chad Swaim

A

Allison Huckins

said almost 4 years ago

I am in the same boat. I applied those fixes and still had an issues. I submitted a ticket and was given the following.

use [DST18000YOURDISTRICT]
GO
GRANT SELECT ON [dbo].[DCV] TO [AIRRole]

This still did not work.

C

Chad Swaim

said almost 4 years ago

We wound up not having permission to the Aeries Online Enrollment Update area in Aeries.com so there was an updates that we had never got permission for. Aeries had to give us permission for that. And then after that we seen an error in Event Viewer that was causing Aeries Online Enrollment to point to the old database so we had to modify the Online Enrollment config file to point to the current database.

Now all is well.

Kevin Praeger

said almost 4 years ago

It is possible you may have some unique situation in your district regarding security. Aeries Support should be able to help you troubleshoot and get this resolved.