Register Server Assembly Dialog Box (Analysis Services - Multidimensional Data)

Use the Register Server Assembly dialog box in SQL Server Management Studio to set the properties of an assembly reference in an Analysis Services database. You can display the Register Server Assembly dialog box by right-clicking the Assemblies folder of an Analysis Services instance or database in Object Explorer and selecting New assembly.

Options

Term

Definition

Type

Select the type of the assembly reference. The following values are available:

ValueDescription
.NET AssemblyThe assembly reference refers to a Microsoft .NET Framework assembly.
COM DLLThe assembly reference refers to a COM library.
Security noteSecurity Note
COM assemblies might pose a security risk. Due to this risk and other considerations, COM assemblies were deprecated in SQL Server 2008 Analysis Services (SSAS). COM assemblies might not be supported in future releases.

File name

Type the full path and file name of the .NET assembly or COM library.

...

Click to display the Open dialog box and select the full path and file name of the .NET assembly or COM library.

Assembly name

Type to set the name of the assembly reference.

NoteNote
Changing this value does not change the name of the assembly referred to by the assembly reference, but instead changes the name used the by the Analysis Services instance or database when referring to the assembly reference.

Include debug information

Select this option to include debug information, if available, for the .NET assembly or COM library.

Create Timestamp

Displays the date and time the assembly reference was created.

Last Schema Update

Displays the date and time the metadata for the assembly reference was last updated.

Source

Displays the source of the assembly reference. This property typically contains the full path and file name of the assembly referred to by the assembly reference.

Safe

Select this option to use this permission set for the assembly reference. If this option is selected, the assembly is allowed only internal computation and local data access. Code executed by an assembly with this option cannot access external system resources such as files, the network, environment variables, or the registry.

Security noteSecurity Note
This option is the recommended permission setting for assemblies that perform computation and data management tasks without accessing resources outside Analysis Services. This option represents the most restrictive permission set.

External access

Select this option to use this permission set for the assembly reference. If this option is selected, the assembly is allowed only internal computation and local data access. Code executed by an assembly with this permission set has the ability to access external system resources such as files, networks, environmental variables, and the registry.

Security noteSecurity Note
This option is recommended for assemblies that access resources outside Analysis Services. Assemblies using this option, by default, execute using the security credentials of the service account. It is possible for code within this assembly to explicitly impersonate the caller’s Microsoft Windows Authentication security context. Because the default is to execute as the service account, permission to execute assemblies with this option should only be given to roles trusted to run as the service account. This option represents a less restrictive permission set than Safe, but more restrictive than Unrestricted.

Unrestricted

Select this option to use this permission set for the assembly reference. If this option is selected, the assembly has unrestricted access to resources, both inside and outside. Code executing from within an assembly with this option can call unmanaged code.

Security noteSecurity Note
This option is not recommended unless the assembly requires unrestricted access. From a security perspective, this option is identical to External access. However, assemblies using the External access option provide various reliability and robustness protections that are not included in assemblies using this option. Specifying this option allows the code in the assembly to perform illegal operations against the process space and hence can potentially compromise the robustness and scalability of Analysis Services. This option represents the least restrictive permission set, and should be used with caution.

Use a specific user name and password

Select this option to have the Analysis Services object use the security credentials of a specified user account.

User name

Type the domain and name of the user account to be used by the selected Analysis Services object. The domain and name of the user account uses the following format:

<Domain name>\<User account name>

NoteNote
This option is enabled only if Use a specific name and password is selected.

Password

Type the domain and name of the user account to be used by the selected Analysis Services object.

Use the service account

Select this option to have the Analysis Services object use the security credentials associated with the Analysis Services service that manages the object.

Use the credentials of the current user

Select this option to have the Analysis Services object use the security credentials of the current user.

Default

Select this option to use the default user account for Analysis Services. Selecting this option is equivalent to selecting the Use the credentials of the current user option.

Description

Type to set the description of the assembly reference.