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
Deploying Analysis service solution
Ivo Leitão
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
mj888
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