Search code examples
ssassql-server-data-toolscubessdt-bissdt-2017

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


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.


Solution

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