How to: Create an Analysis Services Database

  • Article

You can use SQL Server Management Studio to create a new, empty database on an instance of SQL Server 2005 Analysis Services (SSAS).

To create an Analysis Services database

  1. Connect to an Analysis Services instance.

  2. In Object Explorer, expand the node for the connected Analysis Services instance.

  3. Right-click the Databases node of the Analysis Services instance and select New Database.

  4. In the New Database dialog box, in Database name, type the name of the new database.

  5. In Impersonation, provide impersonation information for the new database.

  6. In Description, type the optional description for the new database.

  7. Click OK.

See Also

Other Resources

New Database Dialog Box (Analysis Services)
Administering Analysis Services in Management Studio How-to Topics

Help and Information

Getting SQL Server 2005 Assistance