Swallen Glands Before Menstruation

Edit Administrator role XMLA

In the series "It's always good to know how to do otherwise", a brief presentation of how to change server roles on SSAS other than Management Studio.

To recall, the server role is one that can be a director of SA instance (note: no service AS, but just part of data management, the rights to the service are at the OS ). On

SSMS, we proceed in this way: right click on the instance, then Properties Security .

ASCMD With an XMLA with this head can dispense with Management Studio (a real pain at times):

\u0026lt; Alter AllowCreate = "true " ObjectExpansion = " ObjectProperties " xmlns = " http://schemas.microsoft.com/analysisservices/2003/engine " >

\u0026lt; Object > ;

\u0026lt; RoleID > Administrators \u0026lt;/ RoleID >

\u0026lt;/ Object >

\u0026lt; ObjectDefinition >

\u0026lt; Role xmlns: XSD = "http://www.w3.org/2001/XMLSchema " xmlns: XSi = "http://www.w3.org/2001/XMLSchema-instance ">

\u0026lt; ID > Administrators \u0026lt;/ ID >

\u0026lt; Name > Administrators \u0026lt;/ Name >

\u0026lt; Members >

        < Name > Domaine\Nom </ Name >

        </ Member >

      </ Members >

\u0026lt;/ Role >

\u0026lt;/ ObjectDefinition >

\u0026lt;/ Alter >