Configuring SQL Server

You must configure SQL Server to allow the HotDocs Hub to create databases for Hub components. The database is created the first time a Hub endpoint is accessed. For example, when you load the Templates page in the Hub user interface.

Prerequisites

• Microsoft SQL Server 2012 or later
• Microsoft SQL Server Management Studio

User Account

The HotDocs Hub requires user access to SQL Server. The user used to access SQL Server must also be the user under which the application pool for the Hub is run. This user can be:

• A local account – for example, Network Service
• A Service Account – for example, a specific domain user account
• An SQL Login User

Permissions Required

You must also allocate the following permissions to the user account:

• dbcreator (server role)
• db_datareader (master database role)
• db_datawriter (master database role)

Other Requirements

You must de-select the following user account properties settings:

• User must change password at next login