Configuring SQL Server as database provider

Authority Server defaults to using SQLite for database backend however can be configured to use Microsoft SQL Server instead.

There is currently no support from migrating between database providers.

Supported Versions

SQL Server 2014 or higher.

Database Permissions

The SQL Server user that Authority Server will connect to the server as must be granted the following permissions to the database:

• db_datareader

• db_datawriter

• db_ddladmin

Connection Settings

The below connection settings are found in appsettings.json located in the Authority Server installation directory. Change the provider name to Microsoft.EntityFrameworkCore.SqlServer and connection string to your SQL Server connection string.

For example,

{
  "ConnectionStrings": {
    "DefaultConnection": {
      "ProviderName": "Microsoft.EntityFrameworkCore.SqlServer",
      "ConnectionString": "Server=(localdb)\\mssqllocaldb;Database=EzeScan.AuthorityServer;Trusted_Connection=True;"
    }
  }
}

Database Migrations

Authority Server will automatically create tables and perform migrations at startup.