Article ID: 927942
Article Last Modified on 4/9/2007
APPLIES TO
- ProClarity Analytic Server
SYMPTOMS
When you open a briefing book in the ProClarity Web Standard client, you receive the following error message:
The message also states that details of the condition have been recorded and sent to the Web site administrator. Additionally, the message states that you should contact the administrator if you require immediate assistance.
CAUSE
This issue occurs because the computer that is running ProClarity Analytics Server (PAS) cannot connect to Microsoft SQL Server Analysis Services. This issue has many possible causes. Some of these causes are outside the scope of the ProClarity products. For example, problems with network security, with data integrity, or with general infrastructure functionality may cause this issue.
RESOLUTION
The following are the most common scenarios in which you may experience this issue, together with their resolutions. The issue that you experience may have another cause.
Scenario 1
In this scenario, the following conditions are true:
- PAS and Analysis Services are running on different computers.
- The instance of Microsoft Internet Information Services (IIS) that hosts the PAS virtual directory is located on the computer that is running PAS.
- The instance of IIS is set to use Integrated Windows authentication mode.
Cause
The computer that is running PAS cannot log on to the computer that is running Analysis Services because you cannot use Integrated Windows authentication mode when PAS and Analysis Services are running on different computers.
Resolution
To resolve this issue, use one of the following methods:
- Set IIS to use Basic authentication mode. This setting lets the computer that is running PAS receive credentials and pass them to the computer that is running Analysis Services.
Note When you do this, IIS will display a warning message. The message states that credentials are passed in clear text when IIS uses Basic authentication mode. The user name and password will still be encrypted. However, the encryption will be of a very simple kind. This simple encryption would lower security settings on the computer.
- Move Analysis Services to the computer that is running PAS. If you make this change, you will not have to pass credentials between the computers.
- Do not use any security settings on Analysis Services. This means that everyone will have access to all the information that is on the server.
- Configure the network to use the Kerberos authentication protocol. Then, configure PAS, IIS, and Analysis Services to use the delegation features of Kerberos.
Scenario 2
In this scenario, the computer that is running PAS can receive credentials and can successfully log on to the computer that is running Analysis Services. Therefore, one of the following conditions is true:
- PAS and Analysis Services are located on the same server.
- PAS and Analysis Services are located on separate servers, and IIS authentication is set to the Basic authentication mode.
- You are using the features of the Kerberos protocol.
Cause
This issue may occur because you have sufficient permission to access the data on the computer that is running Analysis Services.
Resolution
To resolve this issue, examine the security roles on the computer that is running Analysis Services. Do this at both the cube level and the database level. Make sure that you have permission to access the data.
Scenario 3
In this scenario, the computer that is running PAS can receive credentials and can successfully log on to the computer that is running Analysis Services. Additionally, one of the following conditions is true:
- The Analysis Services data has recently been migrated to another server.
- The computer name of the computer that is running Analysis Services has been changed.
- One or more of the catalog names have been changed.
- One or more of the cube names have been changed.
Cause
This issue occurs because the connection information for the briefing book is no longer correct. The computer, the catalog, or the cube that the book is looking for no longer exists.
Resolution
To resolve this issue, see ProClarity Analytics Server Administrative Help for instructions about how to change the connection information in a briefing book or in a library.
Keywords: kbtshoot kbprb KB927942
