Database Utilities location

Products

• Information Centric Analytics

Issue/Introduction

You are are trying to locate the Database Utilities folder.

Environment

Release : 6.x

Component : Database Utilities

Resolution

Per the Installing Symantec ICA section of the Symantec ICA Administrator Guide:

"These files are installed on the database server that has Microsoft SQL Server and Microsoft SQL Analysis Server for Symantec ICA."

The default path provided by the installer will be the local equivalent of:

%ProgramFiles%\Bay Dynamics\Database Utilities

If you did not install the Database Utilities in the default path, follow these steps to identify the path used in your environment:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric relational database
3. From the File menu, select New > Query with Current Connection
   A new query editor window opens
4. Copy the following query and paste it into the new query editor window:

   SELECT [Value] FROM RiskFabric.dbo.PortalSettings WHERE [Name] = N'DatabaseUtilitiesFolderPath';

5. Execute the query by pressing the F5 key, clicking the Execute button in the SQL Editor toolbar, or selecting Execute from the Query menu

If you are unable to locate the Database Utilities on the server hosting SQL Server in the path returned by the query, the utilities were likely installed in the path returned by the query on the application server hosting Internet Information Services (IIS) and the Risk Fabric website.