Administering and Monitoring Analysis Services - SQL Server Analysis Services 2012 Cube Development - page 271

Creating and dropping databases
As discussed in Chapter 7 , Analysis Services Security , only SSAS instance adminis-
trators are permitted to create, drop, restore, detach, attach, and synchronize data-
bases. 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 prop-
erties, 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:
1. Right-click on the Databases folder and choose New Database . Doing so
launches the New Database dialog shown in the following screenshot.
2. Specify a descriptive name for the database, for example, Analys-
is_Services_Administration Chapter . Note that the database name
can contain spaces. As you learned in the previous chapters, each object has
a name as well as an identifier. The identifier value is set to the object's origin-
al name and cannot be changed without dropping and recreating the object;
hence, it is important to come up with a descriptive name from the very begin-
ning. You cannot create more than one database with the same name on any
SSAS instance.
3. Specify the storage location for the database. By default, the database will be
stored under the \OLAP\DATA folder of your SSAS installation directory. The
only compelling reason to change the default is if your data drive is running out
of disk space and cannot support the new database's storage requirements.