Sql-Server
SSAS ErrorCode=‘3239575554’ 使用者無權更改“SERVER”對象
我剛剛在名為 SASBIO1 的伺服器上安裝了 SSAS,但是當我嘗試執行下面的腳本時,為了授予特定 AD 組的管理員權限,我收到錯誤消息:
<Error ErrorCode="3239575554" Description="Either the 'mycompany\MMiorelli' user does not have permission to alter the 'SASBI01' object, or the object does not exist." Source="Microsoft SQL Server 2014 Analysis Services" HelpFile="" />
此腳本將 Admin 授予 BIUsersLIVE:
<Batch xmlns='http://schemas.microsoft.com/analysisservices/2003/engine' Transaction='true'> <Alter AllowCreate="true" ObjectExpansion="ObjectProperties" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object /> <ObjectDefinition> <Server xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400"> <ID>SASBI01</ID> <Name>SASBI01</Name> </Server> </ObjectDefinition> </Alter> <Alter AllowCreate="true" ObjectExpansion="ObjectProperties" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <RoleID>Administrators</RoleID> </Object> <ObjectDefinition> <Role xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400"> <ID>Administrators</ID> <Name>Administrators</Name> <Members> <Member> <Name>mycompany\BIUserslive</Name> </Member> </Members> </Role> </ObjectDefinition> </Alter> </Batch>
當我嘗試從 SSMS 執行此操作時,也會發生相同的錯誤,如下圖所示。
我知道我是管理員,我是安裝它的 DBA。
怎麼了?
這真是胡說八道。我右鍵點擊 ssms 並以管理員身份執行,並在那裡添加權限沒有問題。