You can create an empty SQL Server database from a database resource template. The template is configured to allocate resources to the database.

Verify that you have access to the organization and database group in which to create the new database.

Verify that you have Clone permission on the catalog database and Create databases permission on the database group in which you create the database.

Verify that you have Use template permission on at least one resource template, backup template.

1

Navigate to the organization in which you want to create the database.

2

Click the Manage & Monitor tab.

3

Select the database group in which you want to create the database.

4

Click the Databases tab.

5

Click the plus (+) icon to start the Create Database wizard.

6

Click Create new database, and provide the appropriate information.

Wizard page

Action

Creation Type

Click Create new database

General

Specify the database name, type, base database template, and database group from which to create the database.

Name

Type a name to identify the database within the Data Director user interface.

Description

(Optional) Enter a description of this database.

Database Type

Select SQL Server from the drop-down menu.

Base DB Template

Select a base database template from which to create the database from the drop-down menu. For example, SQL Server 2008 R2.

Database Group

If you selected a database group, this field is filled in for you.

Configuration

(Optional) Type the NETBIOS name for the Windows machine to identify the SQL Server database. Specify the configuration information for this database.

Computer name

By default this field is populated with the name you used to identify the database.

Instance

Specify whether to use a Default or Named instance.

A named instance is identified by the network name of the computer plus the instance name that you specify during installation. Client applications must specify both the server name and the instance name when connecting. When SQL Server is installed using the default instance name, it does not require a client application to specify the name of the instance to make a connection. The client only has to know the server name.

Resource Template

Select a database resource template from the drop-down menu. For example, small, medium, or large.

Parameter Group

Select a parameter group for the database or accept the default parameter group. Parameter groups contain database configuration settings such as checkpoint timeout, write-ahead log buffers, encoding, and shared buffers.

Storage

Specify the data, log, and backup disk storage allocation for this database.

Basic Configuration

Specify storage allocation for each disk type. The values you specify are evenly divided among the available disks. For example, if your database uses three data disks, and you specify 6 GB of data disk allocation, Data Director allocates 2 GB of storage space to each data disk.

Advanced Configuration

Specify storage allocation for each disk type, and, if multiple datastores are available, choose the datastore the database should use for its virtual disks. For example, you may choose to map data disks to faster datastores to provide optimum performance, and backup disks to slower datastores where disk performance isn't of critical importance.

Domain

Click Join machine to domain and type a domain name, user name, and password. The domain user must have permisions to join the computer to a domain. By default SQL Server uses Windows authentication when in domain mode.

Click Do not join domain to use mized authentication. When deployed in a Workgroup environment (without joining a domain), SQL Server uses mixed authentication.

Administrator

Specify the SQL Server administrator user name and password.

If you joined the machine to a domain, type a domain user name for the SQL Server administration.

If you did not join the machine to a domain, enter a password for the built-in SQL Server Administrator account, and a password for the Local Windows Administrator.

Options

Expiration

Select a date and time at which the database expires. Then select an action upon expiration, or no expiration.

Tags

(Optional) Select one or more tags for this database. Use tags to filter the list of databases that you view in an organization's Databases tab, for example, all your customer relationship databases can have a tag called CRM.

Snapshot

(Optional) Select the check box to take a snapshot backup of the database when creation and provisioning finishes.

IP Whitelist

Select Allow all connections to the database. Optionally, select Only allow connections from selected IP whitelists (next page), and select an organization IP whitelist or create a custom IP whitelist.

7

Confirm your selections, and click Finish.

You now have a running SQL Server database.

You can add data to the database and starting using the database.