Install SQL Server

Overview

SQL Server may be used to act as the persistant store for Registry information and the JDBC driver that communicates from the Registry to a SQL Server instance is provided within FMR.

Installation

It is beyond the scope of this article to explain how to install SQL Server, but at the current time of writing SQL Server may be downloaded from Microsoft for free.

The SQL Server instance must be accessible to the FMR and FMR will need an database account that can create, update and modify tables.

Setup for use in Fusion Registry

It is recommended to use an empty database in your SQL Server instance for FMR.

Connection Details

FMR requires a database to be specified on the first page of the Install Wizard. This can be changed at a later from the Administrator "Database Settings" page.

SQL Server by default uses port 1433. If you wish to make a custom connection to SQL Server, the information you will likely need is:

Connection String	Of the form: jdbc:sqlserver://<server url>:<server port>;databaseName=<your database> e.g. jdbc:sqlserver://localhost:1433;databaseName=fusion_registry
Dialect	org.hibernate.dialect.SQLServerDialect
Class Name	com.microsoft.sqlserver.jdbc.SQLServerDriver

Instructions

To be written