Pages

Wednesday, November 13, 2013

SSAS Deployment Failed - Error 3 Either the '' user does not have permission to create a new object in '', or the object does not exist. 0 0

This is one of the Most common error a user might face during deploying a SSAS(SQL Server Analysis Services) Cube.

“Error 3 Either the '' user does not have permission to create a new object in '', or the object does not exist. 0 0”

This error occurs because the user who is deploying a cube is not having access to SQL Server Analysis Services(SSAS)

You can follow the below step by step Guide to provide access to SSAS to a User.

Step 1.

Connect to SSAS Server using SQL Server Management Studio.

Step 2.

Once you are connected to SSAS Server, Right click on Server and Click on Properties as shown below.

image

Step 3.

On the properties window of SSAS server properties, click on security Tab and click on Add as shown below

image

Step 4.

provide the user name/group in the Enter the Object Name section and click check Name. Make sure you have selected Groups in Object Types if you want to give access to group. Select Entire Directory in Location.

image

Step 5.

Once the name is resolved, click ok, click ok. Done Now your user should be able to deploy cube without any issues.

Thank you.

No comments:

Post a Comment