Hi
I've created a simple cube with two dimensions and one fact table.
I have access to the SQL server and the analysis server, however when trying
to process the cube I get the following in the process window

Initiating transaction in Database 'TMMPE'
Processing Cube 'LabourCosting' failed. No changes have been made to the
database.
Processing Dimension 'Resources' failed. No changes have been made to the
database.
Initializing Dimension 'Resources'
Data source provider error: Login failed for user '\'.;42000; Time:9/10/2003
11:44:03 AM

Any ideas anyone
Thanks in advance

George

It looks like you might not have access to the OLAP ADM group. Once you add
your userid, it should be fine

"GeorgeO" <sorry (AT) no (DOT) email.com> wrote

It's the classic error :
you have ceduled your cube with the SQL agent and the SQL agent run under
the System Account.
Because your database in Analysis Services used a trusted connection, AS try
to used the System Account to be authenticated with the SQL database.
So, put your SQL Agent under a valid user account which have the right
access to the source SQL database and all it's done !

if you don't used the SQL Agent, the error is the same, just find what is
the service behind the execution process and set this service under a valid
NT account.

another solution is to used a specific user/password in the connection
between you AS and your SQL database. For example, I create a ReaderED
account in SQL server and I used this account in AS to access my source
tables. It's a less secure option.

"GeorgeO" <sorry (AT) no (DOT) email.com> a écrit dans le message de
news:eb%23TGagjDHA.1004 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 2003-09-30