Creating and dropping databases
As discussed in Chapter 7, Analysis Services Security, only SSAS instance administrators are permitted to create, drop, restore, detach, attach, and synchronize databases. This recipe teaches administrators how to create and drop databases.
Getting ready
Launch SSMS and connect to your Analysis Services instance as an administrator. If you're not certain that you have administrative properties to the instance, right-click on the SSAS instance and choose Properties. If you can view the instance's properties, you are an administrator; otherwise, you will get an error indicating that only instance administrators can view and alter properties.
How to do it...
To create a database, perform the following steps:
Right-click on the
Databasesfolder and choose New Database. Doing so launches the New Database dialog shown in the following screenshot.Specify a descriptive name for the database, for example,
Analysis_Services_Administration Chapter. Note that the database...
