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.
