Appendix B: SQL Server Configuration

This help topic covers basic SQL Server setup and configuration suited for use with Silhouette. This guide is offered as a quick start and is not intended to replace the MS SQL Server installation and deployment instructions.

Installing SQL Server

The exact instructions to install SQL Server depend on the SQL Server edition and version. The basic steps are provided below, derived from SQL Server 2014, but it is recommended to read and follow the instructions that come with SQL Server.

1. Run the SQL Server installation executable and click the OK button on the “Choose Directory For Extracted Files” dialog.
2. On the “SQL Server Installation Center” dialog, select the “New SQL Server stand-alone installation or add features to an existing installation” link (towards top right corner of dialog).
3. The SQL Server Setup wizard starts.
4. Select “I accept the license terms” and click Next.
5. On the Feature Selection step ensure the following features are enabled and click Next.
   1. Database Engine Services
   2. Management Tools – Basic
6. On the Instance Configuration step, select the “Named Instance” option and give the SQL server instance an appropriate name, e.g. SQLSILHOUETTE, then click Next.
7. On the Server Configuration, step click Next.
8. On the Database Engine Configuration step, select the “Windows authentication mode” option and click Next.
9. Follow any additional prompts that appear until installation is completed.

Creating a SilhouetteCentral Database

Once SQL Server has been installed a blank database must be created to store all clinical assessment data. This can be created in a number of ways including:

• SQL Server Management Studio
• Windows Powershell

Creating a Database using SQL Management Studio

• From the Windows start menu start SQL Management Studio.
• A Connect to Server dialog should appear. If not, select Connect Object Explorer within the File menu.
• Set the Server type drop down to Database Engine and in the Server name box type .\<SQL SERVER NAME> (e.g. .\SQLSILHOUETTE) then click Connect.
• Within the object explorer pane (left side of screen), right click on Databases and select New Database….
• Within the New Database dialog type in the database name Silhouette and press OK.
• Within the object explorer pane right click on Security and select Login… underneath the New submenu.
• Type IIS AppPool\Silhouette into the Login name text box.
• Select Silhouette within the Default database drop down.
• Click OK.
• Within the object explorer pane expand the Databases item and further expand the sub-item representing the SilhouetteCentral database.
• Right click on Security and select User… underneath the New submenu.
• Type IIS AppPool\Silhouette into both the User name and Login name text boxes.
• In the Membership section scroll down and place a tick beside db_owner.
• Click OK.

Creating a Database using Windows Powershell

Creation of the SilhouetteCentral database may also be scripted via a powershell command prompt:

Invoke-Sqlcmd –ServerInstance .\SILHOUETTE –Query "CREATE DATABASE Silhouette"

Invoke-Sqlcmd –ServerInstance .\SILHOUETTE –Query "CREATE LOGIN

[IIS AppPool\Silhouette] FROM WINDOWS WITH DEFAULT_DATABASE=Silhouette"

Invoke-Sqlcmd –ServerInstance .\SILHOUETTE –Query "USE Silhouette CREATE USER [IIS AppPool\Silhouette] FOR LOGIN [IIS AppPool\Silhouette];"

Required permissions on the Silhouette database:

Invoke-Sqlcmd –ServerInstance .\SILHOUETTE –Query "USE Silhouette exec sp_addrolemember 'db_owner', [IIS AppPool\Silhouette]"