Create your DSWeb Database

1. Launch DataSight Administrator.
2. With the necessary privileges, login to the server where your database is to be created.
3. Click New DSWeb Database in the DataSight Database group of the DataSight Administrator Ribbon. The Create Database view appears in the Main panel.
4. Enter Database Database names can be alphanumeric and include spaces and underscore characters.
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.

DSWeb SQL Server Users

Creating a DSWeb database will also add an SQL Server login (if another login with default login name does not exist) with access to the DSWEB database.  The process will also create an Administrative user for DSWEB.

Provide read permission for dswebuser

The default SQL Server username is dswebuser and this user must have read/write permission for each DataSight database.

1. Find dswebuser under in MSSQL Sever under Security/Logins.
2. Double click dswebuser.
3. Go to User Mapping and setup privileges for each database that is required to be connected to DSWeb. dswebuser will require at least db_datareader permission. If you expect to allow DSWeb users to upload or manually enter data, db_datawriter permission will also be required.
4. Click OK.

If DSWeb users are to be permitted to upload data directly to the DataSight database, DSWeb's IIS User will require write and modify permissions on the Upload folder.