Security Compliance

ARM The Right SQL DB connection setting during initial setup

How to configure DB connection string details to setup ARM DB for first-time users.

First published date

4/11/2019 8:13 AM

Last published date

4/11/2019 8:13 AM

Overview

Most first time users of ARM might come across some errors during DB config/setup after installation of ARM. This article will try to minimize these errors and use the correct config where possible.

Product section

Access Rights Manager

Cause

  • Incorrect SQL connection settings

Resolution

  • If using Local SQL Server with default instance, the installer should pick up the settings and populate it automatically.
  • If using Remote SQL Server with Default Instance, then you only need to enter the SQL DB hostname and leave Instance name blank.
  • If using Remote SQL Server with Named Instance then you have to enter the DB Hostname, Instance Name values