Page Comparison

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 Edition SQL Server Failover Cluster or  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:

Supported editions:

• Express (free)

• Web

• Datacenter

• Standard

• Enterprise

• Microsoft Azure SQL Database

• AWS RDS SQL Database

Create your own database

1. The default schema must

...

1. be dbo.

2. The database must use

...

1. a case-insensitive collation (a collation with a name containing "_CI_").

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

3. If you are

...

1. using Integrated Authentication

...

1.  to connect to your database:
   The account the Tax Balance windows server process runs under must be a member of

...

1. the db_owner

...

1.  role for that database.

2. If you are

...

1. using SQL Authentication

...

1.  to connect to your database, the SQL user account defined in your connection string must be a member of

...

1. the db_owner

...

1.  role for that database.

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

Powershell

$Env:ConnectionString__SmartTaxBalanceDatabase = "<enter connection string here>"

cmd

setx ConnectionString__SmartTaxBalanceDatabase "<enter connection string here>" /M

...