none
The ImpersonationInfo for datasource contains an ImpersonationMode that can only be used by a server administrator RRS feed

  • Question

  • Hi All,

    We have created a new SSAS 2008 R2 DB and we are trying to run the XMLA of DEV Server into Integration Server (new DB).

    We have been given Full Control (Administrator) on the new DB (DB level).

    I am trying to run a ALTER Command (XMLA) at the DB Level and we are getting the below issue:

    "The ImpersonationInfo for datasource contains an ImpersonationMode that can only be used by a server administrator"

    Any help is much appreciated !!

    Thanks,

    Swapnil

    Friday, April 6, 2012 7:24 AM

Answers

  • Hi Jerry,

    Since we do not have Server properties and we do not have policies to give developer user the properties to change the Impersonation Mode, we are facing this issue.

    A work around for this is that the same user if he tries with the AS Deployment Utility instead of the XMLA and specifying the Roles (Retain Roles and Members. The roles and members will not be deployed).

    This way the developer can deploy the structure from one DB to another without having the permissions to execute XMLA Statement.

    Cheers!!

    Swapnil

    Wednesday, May 9, 2012 11:21 AM
  • Hi Swapnil,

    To solve the issue, go to SQL Server Management Studio and connect Analysis Services service, right click on the Analysis Services Instance and select Properties, in the Properties window, click "Security" and add the user used to execute the XMLA statement to the Server administrators.

    Regards,
    Jerry

    Monday, April 9, 2012 2:10 AM
    Moderator

All replies

  • Hello,

    Follow the links below for more help.

    http://support.microsoft.com/kb/922853

    http://blogs.msdn.com/b/john_daskalakis/archive/2009/12/16/9937631.aspx

    Friday, April 6, 2012 11:07 AM
  • Hi Swapnil,

    To solve the issue, go to SQL Server Management Studio and connect Analysis Services service, right click on the Analysis Services Instance and select Properties, in the Properties window, click "Security" and add the user used to execute the XMLA statement to the Server administrators.

    Regards,
    Jerry

    Monday, April 9, 2012 2:10 AM
    Moderator
  • Hi Jerry,

    Since we do not have Server properties and we do not have policies to give developer user the properties to change the Impersonation Mode, we are facing this issue.

    A work around for this is that the same user if he tries with the AS Deployment Utility instead of the XMLA and specifying the Roles (Retain Roles and Members. The roles and members will not be deployed).

    This way the developer can deploy the structure from one DB to another without having the permissions to execute XMLA Statement.

    Cheers!!

    Swapnil

    Wednesday, May 9, 2012 11:21 AM