SQL Server considerations for running multiple instances on the same server:
- As long as each SQL Server instance is installed as a unique named instance, there should be no conflict between them. Each SQL Server instance is installed to a separate directory. Blackbaud's Express installations each install with their own instance name. However, multiple SQL Server instances do have some shared components. Removing one instance should not affect any other instances, but if a problem does occur we recommend uninstalling and reinstalling the affected software.
- The SQL Server 2008 R2 Express instance installed with our software should not be used to run other databases.
- A SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 Standard or Enterprise Edition instance may be used to run multiple databases, including a mix of third-party and/or Blackbaud databases. However, performance will degrade as more databases are added to the same instance.
- If using your own SQL Server 2008 R2 Express instance, then note that Microsoft has limitations on the size of the database that can be used, number of CPUs used and amount of memory (RAM) that can be used which can limit optimal performance. Refer to What are the differences among SQL Server versions? (BB95014)
- We recommend using a dedicated server for each product. For more information refer to the system requirements.
- The database must reside on the same machine as the SQL Server instance which it runs on. The Blackbaud Management Console (BMC) can reside on another machine, separate from the database and SQL Server instance.