Setup MS SQL-Server
dab Nexus uses Microsoft SQL-Server to store:
- Application Data
- Extraction Data
- Result Data
The database for storing application data (you can e.g. call it NexusHome) must be created before dab Nexus is installed.
Database Collation
The database sorting *_CS_AS is expected.
Allow dab Nexus to access the database server
dab Nexus can log in to your database server using either Windows Authentication or SQL-Server Authentication. The recommended setup depends on how your deployment is structured.
- if dab Nexus and SQL-Server are running on the same server -> Windows Authentication recommended
- if dab Nexus and SQL-Server are running on different servers -> SQL-Server Authentication recommended
Windows Authentication
![](https://files.helpdocs.io/sqxl6n6710/articles/qxdg5ycaxw/1655966536925/royal-ts-yw-eqyeone-r.gif)
SQL Server Authentication
![](https://files.helpdocs.io/sqxl6n6710/articles/qxdg5ycaxw/1655966863607/royal-ts-tz-bwr-paa-9-j.gif)
Permissions required by dab Nexus
Application Database
In the application database, it is recommended to assign the db_owner role to dab Nexus.
Alternatively, you can assign the following roles to dab Nexus:
- db_datareader
- db_datawriter
- db_ddladmin
Extracted Data and Results Database
If you want dab Nexus to be able to create databases automatically, give dab Nexus dbcreator on the server.
If you create the databases manually beforehand, assign the dbowner role to dab Nexus.
Encrypt SQL Server Connection
To encrypt the connection to the SQL Server, you only need to tick the Encrypted Connection checkbox.
For more information on how to configure encryption on the SQL Server itself, see the Microsoft Documentation.
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-sql-server-encryption?view=sql-server-ver16
To test if encryption is configured correctly, open the Options when connecting the server in SQL-Server Management Studio and tick the Encrypt connection checkbox.
![](https://files.helpdocs.io/sqxl6n6710/articles/14xem8g4a1/1663572830322/image.png)
If there are any errors, you can check the following things:
- The Enhanced Key Usage property of the certificate specifies Server Authentication
- The common name of the certificate matches the server name used to connect to the server
- If the SQL-Server doesn't start after setting up the certificate, make sure the SQL-Server user has permission to read the certificate