Security properties

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

Analysis Services supports the following security properties.

Properties

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

BuiltinAdminsAreServerAdmins
Does not apply to Power BI. A Boolean property that indicates whether members of the local machine administrators group are administrators.

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).

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.

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

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
Does not apply to Power BI. A string property that contains a comma-separated list of SSPI packages used by the server for client authentication.

ServiceAccountIsServerAdmin
Does not apply to Power BI. 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.

See also

Server properties in Analysis Services
Determine the Server Mode of an Analysis Services Instance