1. Click New Database in the DataSight Database group of the DataSight Administrator Ribbon. The Create Database view appears in the Main panel.
2. Enter Database Database names can be alphanumeric and include spaces and underscore characters.
3. Assign the Administrator User. You can assign any user as an Administrat DataSight users can use either Windows Authentication or SQL authentication for login details.
4. You can check Create Current User as Default Administrator. When you create this user, the person that is currently logged in will be given dbo (database owner) permission and is the owner of the newly created DataSight database (named dbo in the security table for the database).
5. A Microsoft SQL database has two physical files for a database; one for data and one for transaction logs. DataSight automatically sets the location and file name for these files, however you can choose alternate file names and locations. Data and log files don't have to be in the same location. You can put them onto different disks to increase database performance.
6. Click Create. A dialogue box will open with the message Database: "<database name>" has been successfully created.

See also:

• Database Management
• Modes of User Authentication
• Permissions