I have succesfully followed all the steps in the tutorial, but when I
have to deploy my project I get some error messages:

Error 1 The following system error occurred: Logon failure: unknown
user name or bad password. . 0 0
Error 2 Errors in the high-level relational engine. A connection could
not be made to the data source with the DataSourceID of 'Adventure
Works DW', Name of 'Adventure Works DW'. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the
dimension, with the ID of 'Customer', Name of 'Customer' was being
processed. 0 0
Error 4 Errors in the OLAP storage engine: An error occurred while the
'Customer Alternate Key' attribute of the 'Customer' dimension from the
'Analyses Services Tutorial' database was being processed. 0 0
Error 5 The following system error occurred: Logon failure: unknown
user name or bad password. . 0 0
Error 6 Errors in the high-level relational engine. A connection could
not be made to the data source with the DataSourceID of 'Adventure
Works DW', Name of 'Adventure Works DW'. 0 0
Error 7 Errors in the OLAP storage engine: An error occurred while the
dimension, with the ID of 'Customer', Name of 'Customer' was being
processed. 0 0
Error 8 Errors in the OLAP storage engine: An error occurred while the
'Title' attribute of the 'Customer' dimension from the 'Analyses
Services Tutorial' database was being processed. 0 0
Error 9 The following system error occurred: Logon failure: unknown
user name or bad password. . 0 0
Error 10 Errors in the high-level relational engine. A connection could
not be made to the data source with the DataSourceID of 'Adventure
Works DW', Name of 'Adventure Works DW'. 0 0
Error 11 Errors in the OLAP storage engine: An error occurred while the
dimension, with the ID of 'Customer', Name of 'Customer' was being
processed. 0 0
Error 12 Errors in the OLAP storage engine: An error occurred while the
'Middle Name' attribute of the 'Customer' dimension from the 'Analyses
Services Tutorial' database was being processed. 0 0
Error 13 The following system error occurred: Logon failure: unknown
user name or bad password. . 0 0
Error 14 Errors in the high-level relational engine. A connection could
not be made to the data source with the DataSourceID of 'Adventure
Works DW', Name of 'Adventure Works DW'. 0 0
Error 15 Errors in the OLAP storage engine: An error occurred while the
dimension, with the ID of 'Customer', Name of 'Customer' was being
processed. 0 0
Error 16 Errors in the OLAP storage engine: An error occurred while the
'First Name' attribute of the 'Customer' dimension from the 'Analyses
Services Tutorial' database was being processed. 0 0


I think the first one is the error which raises the next errors. Logon
failure. I can logon which the credentials in the sqlserver management
studio, so I can connect to the adventureworks dw database.
Is it for the new database, the Analyses Services Tutorial db? I tried
a lot of things, but nothing seems to work? Does anybody know how to
solve this?

bye,
Julian

Hello Julian,

I have come across a simlar error before. I cover a solution in a post
a couple of months ago. Below is what I posted.

This error is more than likely caused by the Analysis Services service
account not having the permissions to connect to your data source. This

happens when you use windows authentication for the data source
connection and the AS2005 service is running under local system
account.


Try to run the Analysis Services with a windows account that has rights

to connect to your data source. The cube should then process.


Hope this helps,


Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com