Tuesday, 31 July 2012

SSAS - How to fix error The following system error occurred: Logon failure: unknown user name or bad password. .

Errors generated while trying to deploy SSAS project

Error    6    The following system error occurred:  Logon failure: unknown user name or bad password. .       
Error    7    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Data Warehouse', Name of 'Data Warehouse'.       
Error    8    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Store', Name of 'Dim Store' was being processed.       
Error    9    Errors in the OLAP storage engine: An error occurred while the 'Address Id' attribute of the 'Dim Store' dimension from the 'TestAnalysis' database was being processed.     
Error    10    Server: The current operation was cancelled because another operation in the transaction failed.      



To fix:
Double click DataSource then select Impersonation Information tab



Uncheck "Use specific Windows user name and password and select use the service account

1 comment: