What SQL Server permissions are needed to use the software when running in Windows Only authentication mode?

What SQL Server permissions are needed to use the software, if running in Windows Only authentication mode?

All Windows users must be granted the following by a SQL Server Database Administrator (DBA):

  • Member of the public role.
  • View server state permission and be mapped to the database. 
  • For The Raiser's Edge 7.94 or higher, "db_datareader" rights to The Raiser's Edge database.

Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.

Environment

 SQL Server 2008 Express;SQL Server 2008;SQL Server 2008 R2 Express;SQL Server 2008 R2;SQL Server 2012 Express;SQL Server 2012;SQL Server 2014 Express;SQL Server 2014

Was this article helpful?