Export (0) Print
Expand All
Expand Minimize

Register Server Assembly Dialog Box (SSAS)

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.

Term Definition

Type

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

.NET Assembly The assembly reference refers to a Microsoft .NET Framework assembly.
COM DLL The assembly reference refers to a COM library.
Value Description

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.

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.
ms177273.note(en-US,SQL.90).gifNote:

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

This option is enabled only if Use a specific name and password is selected.
ms177273.note(en-US,SQL.90).gifNote:

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.

Community Additions

ADD
Show:
© 2014 Microsoft