Clarity services not starting up with MSSQL named instance

book

Article ID: 209419

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Problem with clarity service connecting to MSSQL DB named instance.

 

App logs:

Clarity 15.9.0.294 failed to initialize.

com.niku.union.config.ConfigurationException: The application failed to start because of a database configuration problem.  Please review the application log for specific error information.

Environment

Clarity 15.9.1

 

Resolution

Configuring MSSQL named instance with static port and not dynamic. Open SQL Server Configuration Manager to enable and set static ports for the SQL named instance 

  1. Open SQL Server Configuration Manager
  2. Expand SQL Server Network Configuration.
  3. Click on Protocols for <Instance Name> ...
  4. If TCP/IP is disabled, right-click on TCP/IP and click on Enable and set a TCP port that is open and not in use. 
  5. Clear the TCP dynamic ports.

 

Attachments