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
Thanks. It worked for me!
ReplyDelete