Cannot Connect to Analysis Services Olap Server

When attempting to connect to a Microsoft Analysis Server from the Crystal Report (v10), the following error message appears:

"The connection could not be established. The logon attempt failed".

I am using Windows XP Pro.

Why is this happening? At the Crystal Report I am using the wizard to create a new report and specifically I am using at the Server options the 1st one (where I specify the Server Name, User Name & Password). Also the 'Server Connection' is 'Direct to the OLAP Server'.

Both the Crystal Report & Analysis Services are running under the same PC, thus there are no network connectivity issues.

I also tried to connect using the Excel to the Analysis Services (where I used the same UserId and Password, to the one I tried with Crystal Reports) and the connection was succesful.

I also checked the Firewall settins, and its ok as the Crystal Report is under the Excpetions.

Why then can't I connect?

There are quite a few questions related to troubleshooting connectivity problems.

First you need to see if you have problem connecting to Analysis Services.
See if this post is going to help you: http://www.sqljunkies.com/WebLog/edwardm/

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.