When drilling through to detail data stored in a database other than
SAS, several items need to be checked:

   1. The database server's authentication domain must be different
      than that used by the host. For example,

         Host authentication = defaultAuth
         DB2 authentication = db2Auth

      The authentication domain is defined in the Server Manager
      definition for the database server.

   2. The library must be defined as preassigned. During the creation
       of the library, click on "Advanced Options" and make sure the
       "Library is preassigned" option is selected. This option will
       ensure that the OLAP Server will retrieve the library information
       from the Metadata Server.

   3. Restart the OLAP Server after making any metadata changes.

If these items are not followed, the OLAP Server log may report errors
about failed connections to the database. For example:

   ERROR: CLI error trying to establish connection: [IBM][CLI Driver]
          SQL1060N User "SASDEMO" does not have the CONNECT privilege.

Operating System and Release Information