Register Database 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: Value Description .NET Assembly The assembly reference refers to a Microsoft .NET Framework assembly. COM DLL The assembly reference refers to a COM library. Security 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. Note 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 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> Note 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.

See Also

Reference

Analysis Services Designers and Dialog Boxes (Multidimensional Data)

Concepts

Multidimensional Model Assemblies Management