Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.
Before logging into FE the first time after install patch 24, log into Windows as an Administrator on the SQL server and verify the Windows account has the following rights in SQL:
  1. On the SQL server, log into SQL Management Studio and connect to the SQL instance where the FE Database is attached
  2. Expand Security > Logins
  3. Open the login for the Windows account that will be running the database updates (the Windows account of the user that will be logging into FE the first time after installing patch 24)
  4. Select Server Roles and mark the following roles:
    • public
    • securityadmin
    • sysadmin
User-added image
  1. Select User Mapping and mark the FE database and ensure database role membership is set to 'db_owner' and 'public'.
  2. Select Securables and ensure Grant is marked for View server state. How to grant View Server State permission to a Windows user/group
  3. Click OK
  4. Ensure no other users are logged into Financial Edge then login and run the database updates.