AS Processing error: Login failed for user '(null)' 1

[Aznawar]

I have developed a datawarehouse and a set of cubes in SQL Server/AS 2000. Now everything is working fine in the development environment where the SQL server and AS is running on the same box, but I have problems getting it to work in the customer's environment.

The customer has a clustered database server running 4 SQL server instances, and an application server running Analysis Services. Lets say the server is named SERVER1, and the SQL instances are called INSTANCE1/INSTANCE1, INSTANCE2/INSTANCE2 and so on.

The data source provider connects to SERVER1/INSTANCE1 using WinNT Integrated security. Test connection is successful.

When trying to process the cube it fails right away with the error message: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.;42000"

I am able to to browse the content of all dimensions and fact tables using Analysis Services.

I've tried many different configurations of the data source provider. I.e. using a different login instead of integrated security, but nothing works...

Any ideas, anyone?

Regards,
Terje
Norway

 

[Aznawar]

I have solved the problem.

The OLAP service was running as Local system account, and was therefore unable to connect to the remote database server.