I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

sql