SQL Server Configuration

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 account used to access SQL Server must be the application pool under which the Hub is run. For example, if you run Hub under the DefaultAppPool, you must add IIS APPPOOL\DefaultAppPool as a user to SQL Server.

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