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 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. |
Description |
Type the description for the new Analysis Services database. |
See Also
Reference
Analysis Services Designers and Dialog Boxes (Multidimensional Data)