As an authentication database, Microsoft SQL Server is used to store:

• accounts
• provisioning
• sessions
• cluster configuration
• entitlement metrics

Setup

1. Download and install Microsoft SQL Server.
2. Manually set the following settings in local.properties:

   db.auth.url=jdbc:sqlserver://localhost:1433;databaseName=edgeAuth
   db.auth.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
   db.auth.dialect=org.hibernate.dialect.SQLServer2012Dialect
   db.auth.username=edgeAuth
   db.auth.password=edgeAuthPassword<will be encrypted on first run>

   Note: If configure.sh is run (preferred), these settings are already set in local.properties.

3. If you are running configure.sh, select SQL Server as Auth DB mode.
4. Create and grant the following:

   use CacheAuthDB
   GO
   CREATE USER "edgeUser" FOR LOGIN "edgeUser"
   GO
   EXEC sp_addrolemember N'db_datawriter', N'edgeUser'
   GO
   EXEC sp_addrolemember N'db_datareader', N'edgeUser'
   GO
   
   CREATE SCHEMA edgeUser AUTHORIZATION edgeUser
   GO
   ALTER USER edgeUser WITH DEFAULT_SCHEMA = edgeUser
   GO
   GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO edgeUser
   GO