Re: Can you update/process AS2005 cube with AMO and SQL authentication

cube metadata vs access to source data are 2 differents things
when you say "We have an application that updates cube metadata
programmatically"
do you talk about an application that add dimension, cubes, measures etc...
in an OLAP Database?
This type of access only use Windows authentication, there is no SQL Server
login because its SSAS not SQL Server.

Can you describe what is your issue, where and when you suffer a limitation?


"Stan Kondrat" <StanKondrat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8CEA8915-22EC-4610-9275-ADE61934F419@xxxxxxxxxxxxxxxx
I have seen a few post on this before. If you use SQL Server user and
password in Data Source connection string, the password is never returned
to
the AMO client. If you're doing any updates to the cube (and call AMO
Update
method) the subsequent Process method will fail because the cube was
updated
with an incomplete connection string.

Is there any way out of this mess? Are we forced to use Windows
authentication to perform this kind of operations? Did Microsoft overdo
something with security here?

We have an application that updates cube metadata programmatically and
cannot prompt the user for the password.

Stan


.