SQL net connect string error

About this task

If you get the error, "The SQL Net connect string shown on the Analytics catalog is BLACKHOLE after installing the Sterling Business Intelligence Framework on a fresh server" when trying to open the catalog:

The catalog's available user classes do not correspond to any defined by the Common Logon Server.

Follow these steps to ensure that the YAF-catalog can be opened:

Procedure

  1. Launch Access Manager Administrator.
  2. Select Root User Class and right-click,
    • Select Add User Class
    • Under the General tab enter "Creator" in the text box for Name.
    • Select the Permissions tab and set the permissions for the Creator user class.
    • Click the Apply button to save information.
    • Click the OK button to return to the Access Manager Administration Tree.
  3. From the Tree select the folder named Users.
    • Select the user (default is administrator) that you would like to associate with the user class, right-click and select the membership tab. Select the user class that the user belongs to. In this case the Creator user class. Alternatively you can associate the user by selecting the user named Administrator, then drag it into the Creator user class.

Results

An error occurs for any user attempting to log into the catalog who does not belong to a specific user class.