Installation Guide for PaperSave for Blackbaud CRM > PaperSave Application Server Configuration

The PaperSave database is hosted on a Microsoft SQL database, and is supported on one of the following versions of SQL:

Database Server	Supported Editions
Microsoft SQL Server 2005, Standard Edition with SP3	32-bit and x64
Microsoft SQL Server 2005, Enterprise Edition with SP3	32-bit and x64
Microsoft SQL Server 2005, Developer Edition with SP3	32-bit and x64
Microsoft SQL Server 2008, Standard Edition	32-bit and x64
Microsoft SQL Server 2008, Enterprise Edition	32-bit and x64
Microsoft SQL Server 2008, Developer Edition with Latest SP	32-bit and x64
Microsoft SQL Server 2008 R2, Standard Edition	32-bit and x64
Microsoft SQL Server 2008 R2, Enterprise Edition	32-bit and x64
Microsoft SQL Server 2008 R2, Developer Edition with Latest SP	32-bit and x64
Microsoft SQL Server 2012, Standard Edition	32-bit and x64
Microsoft SQL Server 2012, Enterprise Edition	32-bit and x64
Microsoft SQL Server 2012, Developer Edition with Latest SP	32-bit and x64
Microsoft SQL Server 2014, Standard Edition	32-bit and x64
Microsoft SQL Server 2014, Enterprise Edition	32-bit and x64
Microsoft SQL Server 2014, Developer Edition with Latest SP	32-bit and x64

Note:

•	PaperSave supports case sensitive and case in-sensitive instances of SQL Server.

•	PaperSave uses SQL Server’s Full Text Search feature for Content Search in PaperSave. Click here to get steps for configuring Full Text Search and iFilters.

•	We do not support the use of SQL Server Express Editions because of Microsoft’s limitation with Database Sizes (Database size is 4 GB for 2005 edition and 10 GB for 2008R2 and 2012 editions, RAM size is 1 GB).

SQL Server Configuration Manager

SQL Server Named Pipes are required to be enabled on the database server which will host the PaperSave database.

1.	Open SQL Server Configuration Manager

Choose Start -> All Programs -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager

2.	Select the SQL instance where the PaperSave database will be hosted

Expand “SQL Server Network Configuration” and locate the instance where the PaperSave database will be hosted. In this example, we are using the MSSQLSERVER instance.

3.	Enable Named Pipes

In the center pane, right-click on Named Pipes and select Enable.

sql server

4.	Restart SQL Server Instance

To apply these changes, you will need to restart the SQL instance where the changes took place. To do so, open the Services console, and locate the SQL server service for the instance. Choose Start -> Control panel -> Administrative Tools -> Services. The service will be named “SQL Server (Instance Name).” In this example, we will restart the “SQL Server (MSSQLSERVER)” service.

services

Note:

•

If using the default SQL instance, the default TCP/IP port is 1433. If using a named instance, there will be a different dynamic TCP/IP port for this instance. In either case, the port for the instance where the PaperSave database is hosted will need to be open on the internal firewall between the PaperSave server and its SQL database server, and in some cases will need to be able to communicate with the client workstations.

•	Best results are obtained when running the PaperSave installation as the service account.