Sql-Server

SSAS ErrorCode=‘3239575554’ 使用者無權更改“SERVER”對象

  • October 7, 2016

我剛剛在名為 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 並以管理員身份執行,並在那裡添加權限沒有問題。

在此處輸入圖像描述

引用自:https://dba.stackexchange.com/questions/107227