SSAS deployment error : user does not have permission to create a new object

0
votes

I recently when I want to deploy my SSAS project to server, faced this error:

Either the domain\user user does not have permission to create a new object in database, or the object does not exist.

enter image description here

I searched on the internet and do some solutions but none worked. I do these steps and it solve the issue.

1
ssassql-server-data-toolscubessdt-bissdt-2017

1 Answers

1
votes

1)Login to SSAS instance on the server.

2)In Role node you should see (at least) one role:

enter image description here

3)In the SSDT in role node in solution explorer define a new role with exactly same role name in SSAS server instance and check all check boxes:

enter image description here

enter image description here

4)In Membership tab add active directory users:

enter image description here

Now you can deploy your project without above error!