Errors while Deploying Analysis services projects in server

Hi,

I am using Sql server Business Intelligence Development Studio 2005 and SQL server Management studio.

I created a Analysis services project in the BI Dev Studio, and set the correct server attributes in the project properties -> deployment tab.

I have created a data source , then a datasource view and then cube and dimensions.

1) When I tried deploying with the database name as 'xyz'. (again set in the project properties -> database ,target attribute),

and the database 'xyz' is previously created and thus present in the Analysis server 2005. I get the following error:

"The database , 'xyz', contains an ImpersonationMode that is reserved for server administrators."

---

2.) When i tried deploying with the database name as 'abc'. (again set in the project properties -> database ,target attribute),

but NOTE now there is no analysis server database with the name 'abc' already existing in the analysis server. now I get the following error:

"Either the 'myUserName' user does not have permission to create a new object in 'myServerName', or the object does not exist."

I checked the Sql server management studio and under the 'xyz' analysis database in the 'Roles' Folder my username is a member of the Administrators who have full priliviges.

Please do tell me as to where I am going wrong.

Thanks and regards

Vijay R

Hi Vijay,

I had the same problem as you and found the following on http://www.eggheadcafe.com/forumarchives/SQLServerdatamining/Jun2005/post23396286.asp. Changing the impersonation mode to the service account sorted things out straight away for me, hopefully it'll do the same for you.

"The impersonation mode tells Anaylsis Server what credentials to use when connecting to the database specified in the datasource object. When you create the datasource using the Data Source Wizard, there's an "Impersonation Information" page where you can set this information. If the data source is used for processing (i.e. you are training mining structures/models from that data source), you are not allowed to set the ImpersonationMode to "Use the credentials of the current user" due to security considerations - you must either use the service account or use a specific username/password. You can change the impersonation mode by opening the data source in BI Dev Studio and selecting one of the allowed options above on the "Impersonation Information" tab."