Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 User permission problem on cube

Author  Topic 

mahadevank
Starting Member

1 Post

Posted - 2014-01-10 : 07:43:16
I have two windows7 account ,one for admin and one for guest account.

I have created a cube in ssas by loggin in windows guest account , while iam executing this i got the error like this..

The user does not have permission to create an object or the object does not exist. If i execute this cube after longin into the windows admin account the cube has been deployed successfully.



So please tell me , how to deploy the cube while iam login in windows guest account.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-01-10 : 08:05:05
you need to give account proper permissions in analysis server database

see
http://technet.microsoft.com/en-us/library/ms174889.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -