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 Configuring Database Properties in Business Intelligence Development Studio.

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 (SSAS)

Other Resources

Working with Analysis Services Databases

Help and Information

Getting SQL Server 2005 Assistance

Change History