How To Topic

Configuring SQL Server for HotDocs Core Assembly Service

Before you can install HotDocs Core Assembly Service, you must configure SQL Server.

In this Topic ShowHide

To configure SQL Server for HotDocs Core Assembly Service

1. Enable FILESTREAM on SQL Server

1. Open SQL Server Configuration Manager.
2. Right-click SQL Server Services.
3. Select Open.
4. Right-click the SQL Server instance you want to configure.
5. Select Properties.
6. Click the FILESTREAM tab.
7. Select Enable FILESTREAM for Transact-SQL access.
8. If the SQL server is on a different machine, you need to allow remote clients access to the File Stream data.
   1. Select Enable FILESTREAM for file I/O streaming access.
   2. Enter the name of the Windows share in the Windows Share Name box.
   3. Since the remote clients must access the FILESTREAM data that is stored on this share, select Allow remote clients to have streaming access to FILESTREAM data.
9. Click Apply.
10. Click OK.

2. Set FILESTREAM access level

1. Open SQL Server Management Studio.
2. Connect to the SQL Server instance you want to configure.
3. Right-click the SQL server instance name in the Object Explorer pane.
4. Select Properties.
5. Navigate to the Advanced page.
6. Select Full access enabled from the FILESTREAM Access Level drop-down list.
7. Click OK.
8. Right-click the SQL server instance name in the Object Explorer pane.
9. Select Restart to restart the server.

3. Create a SQL Server user with dbcreator permissions

The Assembly Service requires a SQL Server user with dbcreator permissions, to create the databases required by the service.