Getting Started > SQL Server settings > Installing SQL Server

Installing SQL Server

This Topic covers:

Instructions
Configuring SQL Reporting Services (SSRS)

Instructions

These instructions are applicable if you have chosen to install SQL Server provided to you for use with Amicus Attorney.

SQL Server must be installed on your Database Server prior to installing Amicus Server. See the “SQL Server readiness” section on page 3 of the SQL Reporting Guide. If you were provided with a 64-bit edition of SQL Server but require a 32-bit edition, please contact Customer Care.

Below are basic instructions for installing SQL Server. Full general instructions are available on screen during the install.

Note: The following screenshots are based on SQL 2014, but the same steps apply to SQL 2017 and SQL 2019.

Log onto the computer you wish to use as your Amicus Database Server, as a user with Windows “Administrators” Group rights. This may be a different computer than your Amicus Application Server.
Insert “SQL Add On” DVD into the disk drive. The Setup program should start automatically. If not, click the Windows Start button, choose Run, and enter [disk drive letter]:\setup.exe.
At the end of this preliminary install, you might be prompted to restart the computer. To resume the installation, insert DVD into the disk drive again.
In the SQL Server Installation Center screen, click Installation at the left, and then click the “New SQL Server stand-alone installation…” option at the right.
The SQL Server Setup wizard starts. Accept the default settings in the subsequent dialogs, EXCEPT:

Feature Selection

Choose the following Instance Features:

Database Engine Services
Reporting Services - Native
Choose the following Shared Features:
Management Tools – Basic
Management Tools – Complete

Instance Configuration

Important: Select “Named instance” option and enter AMICUS. Failure to do this might affect other applications you have running under SQL.

Server Configuration

On the Service Accounts tab, ensure that the SQL Server Agent, SQL Server Database Engine, SQL Server Reporting Services, and SQL Server Browser, services have Account Name set to a user with system administrator privileges (e.g. “LocalSystem”, “NT AUTHORITY” or “NT Service”).

Also ensure that these services have Startup Type set to “Automatic”.

Database Engine Configuration

On the Server Provisioning tab, select Mixed Mode authentication mode and enter a SQL Server password. (You’ll need to use this password later, during the Amicus application installation.)

Click Add Current User or click Add and specify a SQL Server administrator.

Reporting Services Configuration

Important: In the Reporting Services Native Mode section, select the “Install only” option.

Follow the on-screen instructions to complete the install.

Return to page 3 of the SQL Reporting Guide and complete the “SQL Server readiness” procedure.

Configuring SQL Reporting Services (SSRS)

SQL 2017

Note: SSRS (SQL Server Reporting Service) needs to be installed as well, but it can be done before or after Amicus Attorney is installed.

Important: The following instructions must be done after Amicus Attorney is installed as the SQL login “AmicusUser” must exist in the SQL server.

Below are basic instructions for installing SQL Server 2017. Full general instructions are available onscreen during the install.

Run Report Server Configuration Manager

Select Database from the left navigation pane, and click Change Database, to manually create a Report Server Database.

Click Next, there will be 2 prompts for credentials, use AmicusUser for both.

In the Report Server Configuration Manager, select Encryption Keys from the left navigation pane.

A prompt displays click Yes to Delete All Encrypted Content.

Using Amicus, navigate to Firm Settings > General > Reporting Services. Follow the usual process for configuring SSRS (Configure -> Test -> Publish).

If you encounter an issue during publishing reports (error “URI is empty”), click Edit in Step 3 on the Firm Settings screen, and click Save.

Your reports should publish successfully.

SQL 2019

Important: The following instructions must be done after Amicus Attorney is installed as the SQL login “AmicusUser” must exist in the SQL server.

Go to this folder on the Amicus Server:

C:\Amicus\Amicus Attorney Server\SmartClient\Server\SQL2019

Click on the ReportServerConfiguration.exe link to display the ConfigurationForm dialog.

Complete all the fields:

Amicus SQL Instance – Enter your Server name\Amicus
SSRS Instance – Enter your Server name\SSRS
Windows User Name – Administrator
Windows User Password – Enter your Windows password
SQL User Name – AmicusUser
SQL User Password – Enter your SQL User password

Click OK to complete the process.