Create the SCIM application database

The Alfabet SCIM application supports Microsoft SQL Server® and SQLite databases for storage of Alfabet SCIM application internal configuration data. You should use SQLite for test or development environments only.

SQLite does not need a database specification. If you are using Microsoft SQL Server, log in to the database server via the SQL Server Management Studio and create a database and, if not yet available, a login user:

Create a database login user:

1. In the explorer of the SQL Server Management Studio, expand the node Security.
2. Right-click the Logins node and select New Login.
3. In the General tab, set the following:
   • Login name: Specify a user name.
   • SQL Server authentication: Select the checkbox.
   • Password and Confirm password: Enter a password for the login user. The password must have at least 8 characters and contain at least three of the four options: upper case letters, lower case letters, numbers, special characters.
   • Enforce password expiration: Deselect the checkbox.
4. Click Server Roles in the explorer on the right of the editor and select sysadmin.
5. Click OK.

Create a database:

1. In the explorer,In the explorer of the SQL Server Management Studio, right-click the Databases node and select New database.
2. In the window that opens, specify a database name in the Database name field.
3. Click OK to close the New Database dialog. The new database is now visible in the explorer.