Unable to create an Accelerator Configuration Database due to exception 'System.Web.HttpUnhandledException'

book

Article ID: 100050830

calendar_today

Updated On:

Description

Error Message

A DTrace of AcceleratorService will report the following error:

[8928]    (AcceleratorService)    <8096>    EV-L    {EVSqlBase.ShouldRetry} Error 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)' for 'EVSqlConnection: DB: server='SQLServer\InstanceName';Initial Catalog='MASTER';Connection Timeout=120;Connection Lifetime=30;Max Pool Size=200;Integrated Security=True' will not be retried as retry is disabled.
[8928]    (AcceleratorService)    <8096>    EV-H    {EVSqlBase.LogFailureAndThrow} Failed to execute 'EVSqlConnection: DB: server='SQLServer\InstanceName';Initial Catalog='MASTER';Connection Timeout=120;Connection Lifetime=30;Max Pool Size=200;Integrated Security=True' - This command was not retried - Error Error Code: -1 / 80131904 - Severity 20 - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Cause

By default, CA/DA uses TCP/IP Port 1433 to connect the SQL server. When this port is changed for the SQL instance to another value, the connection to the SQL server will failing.

Resolution

Determine what port is configured for SQL instance and provide it while creating Configuration DB in the format: SQLServerName, Port_Number.  For example, if the default SQL listener port of 1433 is changed to 60122 and the SQL Server name is EVSQL, the SQL Server name to specify would be EVSQL,60122 as shown in the screen shot below.

For Example:

Issue/Introduction

Unable to create a Compliance Accelerator (CA) or Discovery Accelerator (DA) Configuration Database (DB) due to exception 'System.Web.HttpUnhandledException'