Create MSSQL database

Configuration-Studio:

Activate TCP and set a static port 1433.

Management Studio:

1. Create a new database:

   

2. Give the database a new name under General

3. Set the appropriate Collation under Options:

   

   Tip: Use the Latin1_General_CI_AS collation for your database with a Latin character set.

4. Under Other options, set the settings IS READ COMMITED Snapshot On and Allow Snapshot Isolation to True:

   

5. Create a new Login to create a new user:

   

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

6. 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:

   

7. Define the user assignment and the database role db_owner:

   

Next step:

Set up a defragmentation job:

• Create maintenance plan for reindexing

• Reindexing in MSSQL Express

• Create and import database