ICA's database components and cube aren't created during installation

Products

• Information Centric Analytics

Issue/Introduction

When installing Information Centric Analytics (ICA) for the first time, an error similar to the following is logged during installation:

Error - SQL Credentials
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '5'.
Unclosed quotation mark after the character string ';
'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at BayDynamics.DatabaseUtilities.SqlServices.SqlCommandService.Execute(String server, String database, String cmd)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at RiskFabric.Installer.Services.InstallServices.InstallStepRunner.Run(IInstallStep step, InstallConfig config)
ClientConnectionId:ae2b252a-c830-48da-b004-762f3da3b6c0
Error Number:102,State:1,Class:15

After installation, the RiskFabric database, jobs, proxies, and credentials are not installed on the SQL Server, and the RiskFabric cube may not be installed on the Analysis Services server.

Environment

Release : 6.5.4

Component : Microsoft SQL Server

Cause

The password for the account specified in the installer for connecting to the SQL Server and/or SQL Server Analysis Services server contains a special reserved SQL character (e.g., a single quotation mark, or ' ). This is interpreted by SQL Server to indicate it has read the entire password being passed to it, resulting in an authentication failure.

Resolution

Change the password of the account to be used to install ICA's database components and cube to not include a single quotation mark character ( ' ).