Monday, March 19, 2012

Errors processing SSAS 2005 Cube against SQL 2000 database

Hi,

I am receiving the following erros when i try to deploy/process my cube. The source db is Sql Server 2000, could this be the issue? I have a connection created (have tried both OLDB providers - SQL Native client and MS OLDB provider) and I am supplying a sql server user name and pass word (datareader permission in db). The 2005 SSAS service is running under a local user account so authentication is not possible using that account. And I have tried various settings under "Impersonation Information" with no luck?

SQL 2K5 sp1 on Win XP sp2

Sql 2k (sp4) on Win2k server

Thanks!

Build started: Project: Aegis, Configuration: Development

Started Building Analysis Services project: Incremental ....

Build complete -- 0 errors, 0 warnings

Deploy started: Project: Aegis, Configuration: Development

Performing a full deployment of the 'Aegis' database to the 'JWILAMETZ\SQLSERVER2005_01' server.

Generating deployment script...

Add Database Aegis

Process Database Aegis

Done

Sending deployment script to the server...

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

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'CURRENCY CD' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

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

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'CURRENCY DESC' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

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

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'DATE ENTERED' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

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

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'EXCHANGE RATE' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

Deploy complete -- 16 errors, 0 warnings

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

First try and see if you connect to your SQL Server 2000 from AS machine.

Login into AS machine under credentials of your local user account and try connecting to your SQL Server machine.

The credentals many customers choosing for their Data Source object is ImpersonateServiceAccount.

Please note. Once you saved user name and password as part of your connection sting, you will have to re-submit username and password every time you update your datasource.

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

|||

Willajo,

can you please let me know how could you solve? I am getting the same error.

thanks a lot in advance...

No comments:

Post a Comment