Analysis Services Deployment Security Issue

We have been working on moving our database from SQL2000 to 2003 the last couple of months. We are now working on our cube migration and have attempted a few deployments. The problem is, every time we try to process the deployed cube it gives us the following error:

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

We only have one connection in this deployment and have tried with various cubes all the way down to one dimension.

Our connection always tests successfully on the dialog box itself, we have attempted both, windows and SQL authentication, and both always yield the same error.

Up to this point we have not able to process any cube we have attempted.

As far as I can tell our SQL and Analysis services both are set to the same instance name, but I’m thinking this may be a configuration issue, since it seems that internally Analysis services just cant contact SQL services.

Anyone has an idea of what may be wrong with the configuration?

Have you tried setting the Impersonation Information to Default, and including the user name and password in the connect string?|||Hmm, I had not tried that. Attempted it now and it worked.

This solves my problem but now I question why would the other settings not work?