OLAP Server Problem

[Naeem]

I am using OLE DB Provider for OLAP Services 8.0, from within Crystal
Reoprts 9.0, to connect to SQL Server 7.0 OLAP Server Cube on another
Server through LAN. I am getting an error message "User could not be
authenticated (due to security problems). Native Error No. 2422". I am
supplying correct server name, user name and password in OLE DB (ADO)
dialog box. Using Windows XP on client side and 2000 server on server
side.
The file MSOLAP80.dll exists at "C:\Program Files\Common
Files\System\Ole DB\". Please help...

[MGFoster]

Naeem wrote:

I am using OLE DB Provider for OLAP Services 8.0, from within Crystal
Reoprts 9.0, to connect to SQL Server 7.0 OLAP Server Cube on another
Server through LAN. I am getting an error message "User could not be
authenticated (due to security problems). Native Error No. 2422". I am
supplying correct server name, user name and password in OLE DB (ADO)
dialog box. Using Windows XP on client side and 2000 server on server
side.
The file MSOLAP80.dll exists at "C:\Program Files\Common
Files\System\Ole DB\". Please help...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The obvious question is "Does the user have permission to access the
Cube?"

I've found that using Windows Authentication seems to work better/easier
than SQL authentication. Just set the connection parameter
"Trusted_Connection" equal to "Yes."
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQzluU4echKqOuFEgEQIv4gCfdGiwiDXgXeTqtvyiwjd/j71zoxsAoN7f
Zpi7Hrzb1A2MnLUHKMbtAxD9
=RywA
-----END PGP SIGNATURE-----