The SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 or SQL Server 2014 default installation options must be changed in order to access Blackbaud databases. Check each of the following items carefully before attaching a Blackbaud database to a SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 or SQL Server 2014 instance.
IMPORTANT: For SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 , or SQL Server 2014 compatible products, be sure to back up the database while the database is still attached to the original/previous SQL Server Instance. Backups created with later versions of SQL Server are incompatible with previous versions of SQL Server due to the required revisions made to the database files by the later SQL Server version.
- Review the latest system requirements for your product before updating.
- Verify that the version of the Blackbaud product you are using is compatible with SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 or SQL Server 2014
- Enable the TCP/IP and Named Pipes protocols for your SQL Server instance.
- If a firewall is in place on the server, create exceptions for the SQL Server port.
- In order to use the Blackbaud Management Console (BMC), add the appropriate Windows accounts as logins in SQL Server and assign them sysadmin rights.
- If you are using Windows only authentication* in SQL Server, users must have public role access to the Blackbaud database and have View server state permission.
- If using Windows only authentication in SQL Server and The Raiser's Edge 7.94 or higher, then in addition, users must be granted "db_datareader" rights to The Raiser's Edge database.
- If the Blackbaud Management Console (BMC) is installed on a separate server from SQL Server, then you must also download and install the Microsoft SQL Server 2005 Backwards Compatibility Components
- NOTE: On the Microsoft Download page, instead of clicking the Download button, scroll down and expand "Install Instructions" > then locate "Microsoft SQL Server 2005 Backward Compatibility Components" > and then download and install either the X86 Package or X64 Package (depending upon whether you are using a 32-bit or 64-bit version of SQL Server)] on your SQL Server.
- SQL Server Standard or Enterprise Edition databases must still be attached via the Blackbaud Management Console (BMC). Refer to How to use SQL Server Standard or Enterprise Editions instead of the Express Editions for instructions.
- Review the appropriate scope of support for your maintenance level.
*Note: if you have BBNC, you may need to select SQL Server and Windows Authentication mode (mixed mode). To implement this, right click on the SQL Server instance, click Properties, select Security, select SQL Server and Windows Authentication mode, click OK and restart your SQL Server instance.
Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.