My First time trying to deploy a cube
Hi
I'm going through an online training trying to deploy my first AS 2005 cube and i've fallen at the first hurdle.
I'm getting the following error:
Error 1 Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Login failed for user .......
Where is the app. getting this login from because it 's not one i've set up.
Thanks
[521 byte] By [
Rhona] at [2007-12-24]
Hi. Check the authentication in your data connection in the project.
It can be related to impersonation(the second tab in the connection). If you are part of the local administrators group on your workstation and both the database and Analysis Services are installed here it should be sufficient with windows authentication and to use the service account for impersonation.
Under impersonation option, if you choose "Impersonate Current User" will not work with processing.
I have read recommendations to use Default for impersonation.
Try the options under impersonation and return if it does not work.
Regards
Thomas Ivarsson