New Database Dialog Box (Analysis Services)

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.

Options

Term	Definition
Database name	Type the name of the new Analysis Services database.
Use a specific user name and password	Select 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 name	Type 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.
Password	Type the password for the user account specified in User name.
Use the service account	Select 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 user	Select 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.
Default	Select 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 Database Properties (Analysis Services - Multidimensional Data). 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.
Description	Type the description for the new Analysis Services database.

See Also

Reference

Analysis Services Designers and Dialog Boxes (Analysis Services - Multidimensional Data)

Concepts

Defining an Analysis Services Database