SQL Database Configuration

Learn how to create a new SQL database for your Innoslate Enterprise environment through these step-by-step instructions.

Prerequisite:

•  Full Text Search must be enabled in order for Innoslate to work.

SQL Server Database Configuration

1. Create a new database in SQL Server 2012 or newer

   1. Open Microsoft SQL Server Management Studio

1. 1. Right click “Databases” in “Object Explorer”

   2. Enter a database name

   3. Click “OK”

2. Set the username and password for the new database.

   1. Navigate to “Security” in “Object Explorer”

   2. Select “Logins”

   3. Right click “New Login”

   4. Select SQL Server Authentication

   5. Enter a secure username and password

   6. Uncheck “Enforce password expiration”

   7. Grant permission to the Innoslate database

      

       

      1. Select “User Mapping”

      2. Select “Map”

      3. Select desired permissions

3. Configure database back up. See this Microsoft Developer Network page for more information.

Note: Backing up your SQL database is essential for protecting your data.