How to setup your database before installing Venio

Database Server (SQL) Configuration Recommended workflow

1. Create SQL User Account

• Log into SQL Management Studio provided username and password.

Example Username: veniosql and Password: veniosql.

2. Right-click on Security and go to New > Login.

3. Enter venio1sql as the Login name.
4. Select SQL Server authentication.
5. Enter venio1sql in the Password and Confirm Password fields.
6. Select the Server Roles page

7. Check sysadmin roles and click OK.

Configure MDF and LDF Data Location

1. Right-click on SQL Server and select Properties.

2. Select the database settings page.

Set the Data, Log and Backup location and hit OK.