Cannot Deploy Cube to Server

Hi,

I have created a new Cube where the data source itself is not on a SQL Server (DB2 in my case). Now if I try to deploy my Cube it brings an error messages:

(Translated from German)

System error: Login failed: Unknown user or bad password

I could break down the problem until the point that I assume it has to do with the fact that during the deployment process the BI Studio tries to use the same account defined in my data source to access the non SQL Data source as well as the login for the SQL Server 2005 database to store the analysis data.

How can I change the deployment process so it will use one account for the source data and another one as a login for the analysis database?

Thanks.

Ertan

I would guess that connection is attempted under your Analysis Sever service account.

Check if that has sufficient privileges.

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

|||Where do I have to set or check this?|||

To see the account your Analysis Server is running you can use SQL Server Configuration Manager application installed SQL Installation->Configuration and Tools.

See what user Analysis Server is running under and try connecting to your Oracle database under it's credentials.

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

|||Also, what is the impersonation account specified for your data source? You can set this either to Service Account or a specified user account - this would enable you to specify a user account to connect to the underlying data source (giving this account the appropriate permissions) rather than giving these permissions to the Analysis Services service account.|||

Actually let me correct myself here.

Connecting to Oracle you should check:

First. The account under which your data source connection is impersonated should have sufficient privileges to connect Oracle machine. Deepened on the way you specified data source can be impersonated under service account or under specific user credentials you specified as part of your data source.

Second. When connecting to Oracle machine, you should specify correct user name and password as part of your connection string.

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