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

• If you are using a Trusted Connection to connect to the Hub databases, you must also add the application pool user under which Hub runs to the SQL Server users (e.g. IIS_APPPOOL/hubAppPool), giving them the permissions listed below.

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