Deploying Analysis service solution

Greetings,

How do I deploy an Analysis services project on to diference machines. I have followed the process laid out in MSDN and changed the server to the remote server name while deploying. It throws up an error that the user does not have permissions to create objects on remote server.

Please help me understanding the process of deployment and how the analysts can open up the deployed cube in their machines

Thanks/Regards

Shiv

You must had the users in the security panel of your remote Analysis Services.

In Microsoft SQL Server Management Studio, open a connection to your Analysis Services Server. Click Right on the name of your server (XXXX (Microsoft Analysis Services...))

Choose Properties, Security, and add the users that must access to your server

|||

Hi,

I am facing the same problem, i did as u said and got the following error:

TITLE: Connect to Server

Cannot connect to myserver.

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

An existing connection was forcibly closed by the remote host (System)

BUTTONS:
OK

pls any help ?

Thanks

Tarek Ghazali

MS SQL Server MVP