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
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>