Security Properties

Microsoft SQL Server Analysis Services supports the security server properties listed in the following table. To view or change these properties for an instance of Analysis Services, in SQL Server Management Studio, right-click the Analysis Services instance, and then click Properties.

Properties

  • RequireClientAuthentication
    A Boolean property that indicates whether client authentication is required.

    The default value for this property is True, which indicates that client authentication is required.

  • SecurityPackageList
    A string property that contains a comma-separated list of SSPI packages used by server for client authentication.

  • DisableClientImpersonation
    A Boolean property that indicates whether client impersonation (for example, from stored procedures) is disabled.

    The default value for this property is False, which indicates that client impersonation is enabled.

  • BuiltinAdminsAreServerAdmins
    A Boolean property that indicates whether members of the local machine administrators group are Analysis Services administrators.

  • ServiceAccountIsServerAdmin
    A Boolean property that indicates whether the service account is a server administrator.

    The default value for this property is True, which indicates that the service account is a server administrator.

  • ErrorMessageMode
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • DataProtection\ RequiredProtectionLevel
    A signed 32-bit integer property that defines the required protection level for all client requests. This property has one of the values listed in the following table.

    Value

    Description

    0

    None, clear text allowed.

    1

    (Default) Encryption required, no clear-text logging.

    2

    Clear-text requests allowed but only with signatures (weaker protection than encryption).

  • AdministrativeDataProtection\ RequiredProtectionLevel
    An advanced property that you should not change, except under the guidance of Microsoft support.