Create MSSQL database

Configuration-Studio:

Activate TCP and set a static port 1433.

Management Studio:

1. Create a new database:

   

2. Enter a name and set the options:

   

3. Create a new user:

   

   Note: One SQL user must be created for each SQL database.

4. Select an SQL user and set the database for which the user is to be used as the default database. In Aeneis, the connection to the database is then created with this user:

   

5. Set a role for the user:

   

Next step:

Set up a defragmentation job:

• Create maintenance plan for reindexing

• Reindexing in MSSQL Express

• Create and import database