1. From the Blackbaud NetCommunity Web Server, navigate to the NetCommunity installation folder then go to ~\Blackbaud\bbappfx\MSBuild
    • Note: this may be a folder similar to C:\Program Files (x86)\\Blackbaud\bbappfx\MSBuild though the exact location may vary, based on where you saved it. 
  2. Double-click on the executable bbAppFx.Config
  3. Select the option for RunServiceRevisions from the column on the left.
  4. In the SQLConnectString field, confirm the server and database name is correct
    • If you are not logged in as a Windows User with administrator rights over the NetCommunity SQL Server box, remove the 'integrated security=SSPI' section of the SQL Server Connect String and replace this with one of the following:
      • 'Uid=dB_Owner' ;Password=********'. Fill in the password.
      • 'Uid=SA' ;Password=********'. Fill in the password.
      • Note: You must enter a SQL User Name and Password that has SYSADMIN rights within SQL Server.
  5.  Click GO

Note: The BBPortalWebUser cannot be used to run database revisions as this user does not have the appropriate permissions to update the database.

Alternate Solution: (To be used if above fails.)
  1. Copy MSBuild Folder from Blackbaud NetCommunity Application Server  <Default Location> C:\Program Files\Blackbaud\BBAppFX\MSBuild to location directly on SQL Server
  2. Run BBAppFX.Config  from MSBuild folder on SQL Server - Proceed as above.