Processing error

Hi all,

This came up and I have never see it before, I have tried logging in as sa and by using Windows Authentication and both give the same error. The error below occurred while using sa and the password. I get the same thing when I use WA (I am sysadmin).

Anyone have any ideas about what could be causing this?

Thanks,

Roy

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Parallel>

<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Object>

<DatabaseID>Pipeline Cube</DatabaseID>

<DimensionID>Tbl Pipeline Date</DimensionID>

</Object>

<Type>ProcessFull</Type>

<WriteBackTableCreation>UseExisting</WriteBackTableCreation>

</Process>

</Parallel>

</Batch>

Processing Dimension 'Tbl Pipeline Date' completed successfully.

Start time: 2/24/2006 9:01:52 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:05

Processing Dimension Attribute '(All)' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:53 AM; Duration: 0:00:00

Processing Dimension Attribute 'DYear' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'Quarter' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'MonthNumber' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'ActualDate' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'WeekNumber' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'DayOfWeek' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'DayOfMonth' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'MonthName' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Errors and Warnings from Response

The following system error occurred: Logon failure: unknown user name or bad password. .

Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works', Name of 'Adventure Works'.

Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Tbl Pipeline Date', Name of 'Tbl Pipeline Date' was being processed.

Errors in the OLAP storage engine: An error occurred while the 'Quarter' attribute of the 'Tbl Pipeline Date' dimension from the 'Pipeline Cube' database was being processed.

Have you configured your data source to use the service account credentials? Analysis Services only supports that setting.

_-_-_ Dave

|||

Dave,

You are correct. I had forgotten all about using the service account credentials.

Thanks,

Roy