I have a C# installer that deploy a XMLA to a SQL Server SSAS 2005. My installer ask to provide a AD username and password to deploy the XMLA on the target serveur with SSAS. What are the permission needed to deploy a XMLA on a SSAS server ???.
The AD user have sysadmin,dbcreator and public access in the Server Role node on the SQL Server where SSAS is located and its still poping that the user don't have the right to "deploy" the XMLA. (Its working tho if the user is admin of the server PC)
Chunk of the code :
imp = new Impersonation(session["DBMASTER"], session["DBMASTER_PWD"]);
XmlaClient clnt = new XmlaClient();
string xmla = File.ReadAllText(strXMLA);
Richard Martin Web Developer / BI Developer
View Complete Post