Setting of DBPROP_AUTH_USERID fails with "Analysis Services 9.0 OL

[Database Administrator]

Setting of DBPROP_AUTH_USERID fails with "Analysis Services 9.0 OLE DB
Provider" but used to work for "Microsoft OLE DB Provider for OLAP Services
8.0".

I have a application scenario as follows.

A server process say processA(machineA) uses ODBO(ole db provider for OLAP)
to connect to SSAS 2000 running on different machineB.

There are say two users domain\user1 and domain\user2. Both users have
access to cubes in SSAS.

domain\user1 logged in on first machine where processA is running and also
on machineB where SSAS 2000 is running.

processA follows the following steps for connection:
1> Impersonate the user using LogonUser and ImpersonateLoggedOnUser. (this
step succeeds)
2> Set connection properties and
3> initiate connection

processA sets few connection properties along with DBPROP_AUTH_USERID
property which is set to user who tries to access cube. Now when domain\user2
tries to connect to SSAS 2000, DBPROP_AUTH_USERID is set to domain\user2 and
SetProperties() is called.

CASE 1:
When processA uses "Microsoft OLE DB Provider for OLAP Services 8.0"
SetProperties() works fine without any errors/warnings and connection
succeeds.

CASE 2:
When processA uses "Analysis Services 9.0 OLE DB Provider" it reports an
error in SetProperties():

[ 1] Microsoft OLE DB Provider for Analysis S: The following system error
occurred: The system cannot find the file specified. .

CASE 3:
When domain\user2 is logged in on machineA and processA uses "Analysis
Services 9.0 OLE DB Provider" then SetProperties() works fine without any
errors/warnings and connection succeeds.

This gives a feeling that there are some checks added in "Analysis Services
9.0 OLE DB Provider" for DBPROP_AUTH_USERID property.

I have two questions:

1> Is it OK to NOT set DBPROP_AUTH_USERID property as the processA is
already impersonating the user trying to connect to SSAS? Because if I dont
set DBPROP_AUTH_USERID property then my application is able to connect.

2> Does "Analysis Services 9.0 OLE DB Provider" interpret DBPROP_AUTH_USERID
property differently?


Thanks in advance,
Kaustubh D