sql-servervisual-studiovisual-studio-2017ssassql-server-2016

Can't add members to SSAS role through Visual Studio


I'm unable to add members to an SSAS role through Visual Studio. I can create a role in Visual Studio. I can add member through SSMS but cant add members through my Visual Studio project. The problem comes when I need to deploy my solution, all members added through SSMS disappear; hence, I need to solve the problem of not being able to add members through my project in Visual Studio. maybe I need to give Visual Studio some permission?

I expect to be able to add members through my SSAS Visual Studio project and when I deploy the project again the members of the role don't get affected.

Right now, when I click on the Add.. button nothing happens

Snapshot of the Visual Studio


Solution

  • I have the same issue in Visual Studio SSDT 2017

    My workaround is to hit "F7" on the associated role (or right-click and go to view code.) You'll see that the role is just XML anyways and you can easily add a new <Member> and <Name> Attribute

    For example, here is the XML for my test role:

    <Role xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400" xmlns:ddl500="http://schemas.microsoft.com/analysisservices/2013/engine/500" xmlns:ddl500_500="http://schemas.microsoft.com/analysisservices/2013/engine/500/500" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" dwd:design-time-name="7979a90c-d53d-4f48-8969-4bd239b43346" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
      <ID>Test Role</ID>
      <Name>Test Role</Name>
      <CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
      <Description>Role for testing</Description>
      <Members>
        <Member>
          <Name>127.0.0.1\TestUser</Name>
        </Member>
      </Members>
    </Role>