SQL Server is not found or not accessible

Products

Information Centric Analytics

Issue/Introduction

While running the Symantec ICA Installation Wizard, the installer displays the following error message when you provide the hostname or IP address for the SQL Server instance that will host the RiskFabric relational database:
```
SQL Server not found.
```
The Run Staging Procedures step of the nightly RiskFabric Processing job or the RiskFabric Intraday Processing job fails and the following error message is logged in the SQL Server Agent log:
```
Error Msg: Named Pipes Provider: Could not open a connection to SQL Server [53].
```

The Risk Fabric cube processing step of the nightly RiskFabric Processing job fails in a two-tier environment in which both SQL Server and SQL Server Analysis Services (SSAS) are hosted on the same server. Both services are running and Named Pipes are enabled for the SQL Server service. The following error message is logged by the SQL Server Agent:

OLE DB error: OLE DB or ODBC error: Login timeout expired, HYT00, A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online., 08001, Named Pipes Provider: Could not open a connection to SQL Server [2]. , 08001.

Environment

Version : 6.x

Component : Installation Wizard, RiskFabric Processing, RiskFabric Intraday Processing, Microsoft SQL Server, Microsoft SQL Server Analysis Services

Cause

These failures can be caused by any of the following conditions:

The account under which the installation wizard is running is not a login in the target SQL Server instance
The server hosting SQL Server has not been joined to the same domain as the account under which the installation wizard is running
The SQL Server service is not running on the server hosting SQL Server and the RiskFabric relational database
The RiskFabric relational database is hosted in a named instance of the SQL Server service but the data source connection string for the RiskFabric Analysis Services database (ASDB) is configured to point to the default SQL Server instance

Resolution

SQL Server and Domain Credentials

Information Centric Analytics (ICA) uses Integrated Windows Authentication (IWA) to validate accounts against Active Directory. For this to work properly, all servers hosting ICA components (Internet Information Services (IIS), SQL Server, SSAS) must be a member of the same Windows domain and the account under which the installation wizard is running must be an account in that domain.

In addition to this requirement, the installation wizard must be run under an account that meets the privileges requirements published in the Required Installation Privileges and Credentials section of the Symantec ICA Administrator Guide. In simplest terms, the account must:

Be a member of the local administrators group on the servers hosting IIS and SQL Server (Broadcom recommends configuring this by adding the domain account or a domain group in which it is a member to the local administrators group)
Be assigned the sysadmin role in SQL Server
Be a member of the Server Administrators group in Analysis Services

NOTE: The installation wizard does not create service and administrator accounts; instead, you pass it valid accounts that already exist in Active Directory.

Once all servers hosting ICA components have been joined to the same domain and you have created accounts in Active Directory to use as the ICA service account and as a Risk Fabric console administrator, you should ensure the console administrator account has been granted the privileges listed above and then run the installation wizard under that account.

If your organization's security policies restrict the use of the sysadmin role, you may downgrade the ICA service account's privileges after installing ICA by following the procedure documented in the Permission Settings for the ICA Service Account Outside of Using the SQL Server sysadmin Role section of the Symantec ICA Administrator Guide.

Start the SQL Server Service

Start the SQL Server service on the server hosting SQL Server and the RiskFabric relational database by following these steps:

Run PowerShell as an administrator
Copy one of the following options and paste it in PowerShell:
1. If the RiskFabric relational database is hosted in the default SQL Server instance:
```
Start-Service -Name 'MSSQLSERVER'
```
2. If the RiskFabric relational database is hosted in a named instance of SQL Server:
```
Start-Service -Name 'MSSQL$<InstanceName>'
```
Press Enter to execute the command

NOTE: The following PowerShell cmdlet will return a list of SQL Server instance service names:

Get-Service *SQL*

Update the ASDB Data Source Connection String

Verify and/or update the OLAP cube's data source connection string by following these steps:

Open SQL Server Management Studio (SSMS)
Connect to the Analysis Services server hosting the RiskFabric OLAP cube
In Object Explorer, navigate to Databases > RiskFabric > Data Sources
Right-click the RiskFabric data source and select Properties

The Data Source Properties - RiskFabric window opens
Under the General heading, select the Connection String and click the ellipsis to the right of the string

The Connection Manager window opens
From the Provider dropdown menu, select Microsoft OLE DB Driver for SQL Server
Enter the name of the server and instance name hosting SQL Server and the RiskFabric relational database

NOTE: Specify the instance name after the server name with a trailing \<instance-name>
From the Initial catalog dropdown menu, select the RiskFabric relational database
Click the OK button to save your settings and close the Connection Manager window
Click the OK button to save your settings and close the Data Source Properties - RiskFabric window