Forum Discussion

bergerlu's avatar
bergerlu
Helper I
5 years ago

PBI Embedded Capacity SSMS error

Hello,   I am connected to a PBI Embedded Capacity with SSMS. When I try to go in the advanced properties, I get this error. I am the owner and administrator of the capacity. What am I doing wrong ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi bergerlu 

 

The error message indicates that you should also be the administrator of the Analysis Services server you are trying to edit, not an admin of a database or model. If you are already an admin of the AS server and see the error, you may exit SSMS application, right-click on SSMS and select Run As Administrator. If you are not an admin of it, you may ask the server admin to help add you as an admin. Please see the reference below about how to add a server admin:  

https://docs.microsoft.com/en-us/analysis-services/instances/grant-server-admin-rights-to-an-analysis-services-instance?view=asallproducts-allversions

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/18c32c87-54de-4474-b7a0-f67c8d3e4627/how-to-add-admin-account-to-ssas-2012?forum=sqlanalysisservices

 

Hope this helps.

 

Best Regards,

Community Support Team _ Jing Zhang