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

Next Steps

Install ApacheDS.

Table of Contents

Index

Glossary

-Search-

Back