New Database Dialog Box (Analysis Services)

 

Applies To: SQL Server 2016

Use the New Database dialog box in SQL Server Management Studio to create a new, empty Analysis Services database. You can display the New Database dialog box by right-clicking the Databases folder of an Analysis Services instance in Object Explorer and selecting New Database.

TermDefinition
Database nameType the name of the new Analysis Services database.
Use a specific user name and passwordSelect to have the Analysis Services database use the security credentials of a specified user account. The specified credentials will be used for processing, ROLAP queries, out-of-line bindings, local cubes, mining models, remote partitions, linked objects, and synchronization from target to source. For DMX OPENQUERY statements however, the credentials of the current user will be used.
User nameType the domain and name of the user account to be used by the selected Analysis Services database. Use the following format:

 <Domain name> \ <User account name>

Note: This option is enabled only if Use a specific user name and password is selected.
PasswordType the password for the user account specified in User name.
Use the service accountSelect to have the Analysis Services database use the security credentials that are associated with the Analysis Services service that manages the database. The service account credentials will be used for processing, ROLAP queries, remote partitions, linked objects, and synchronization from target to source. For DMX OPENQUERY statements, local cubes, and mining models the credentials of the current user will be used. This option is not supported for out-of-line bindings.
Use the credentials of the current userSelect to have the Analysis Services database use the security credentials of the current user for out-of-line bindings, DMX OPENQUERY statements, local cubes, and mining models. This option is not supported for processing, ROLAP queries, remote partitions, linked objects, and synchronization from target to source.
DefaultSelect to use the credentials of the default user account for Analysis Services. This option uses the default setting for the database for processing objects, synchronizing servers, and executing Open Query data mining statements. For more information about specifying the default settings at the database level, see Set Multidimensional Database Properties (Analysis Services).

By default the DataSourceImpersonationInfo database property is set to Use the service account. Regardless of the DataSourceImpersonationInfo property value, the credentials of the current user will be used for out-of-line bindings, ROLAP queries, local cubes, and data mining models.
DescriptionType the description for the new Analysis Services database.

Analysis Services Designers and Dialog Boxes (Multidimensional Data)
Multidimensional Model Databases (SSAS)

Community Additions

ADD
Show: