Versions Compared

Old Version 6

changes.mady.by.user CBE

Saved on

compared with

New Version Current

changes.mady.by.user Mario Sandhövel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Tax Balance stores relational in a Microsoft SQL Server Database.

SQL Server Database

Tax Balance works with a wide range of versions and editions of SQL Server, from a local SQL Server Express instance, all the way to an Enterprise Edition SQL Server Failover Cluster or SQL Server AlwaysOn Availability Group, or even one of the hosted database-as-a-service offerings.

The following versions of SQL Server Database are supported:

Tax Balance

Minimum SQL Server version

Azure SQL

2022.0.0 → latest

SQL Server 2016+

Supported

Supported editions:

  • Express (free)

  • Web

  • Datacenter

  • Standard

  • Enterprise

  • Microsoft Azure SQL Database

  • AWS RDS SQL Database

...

  1. The default schema must be dbo.

  2. The database must use a case-insensitive collation (a collation with a name containing "_CI_").

  3. The database must have a compatibility level of 130 or greater.

  4. If you are using Integrated Authentication to connect to your database:
    The account the Tax Balance windows server process runs under must be a member of the db_owner role for that database.

  5. If you are using SQL Authentication to connect to your database, the SQL user account defined in your connection string must be a member of the db_owner role for that database.

  6. Configure database connection by providing a proper connection string. Use appSettings.json file or an enviroment variable ConnectionString__SmartTaxBalanceDatabase 

...