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 |
...
- The default schema must be dbo.
- The database must use a case-insensitive collation (a collation with a name containing "_CI_").
- If you are using Integrated Authentication to connect to your database:
- The user account installing Octopus must be a member of the db_owner role for that database.The account the Octopus Deploy the Tax Balance windows server process runs under (by default, the
Local System
account) must be a member of the db_owner role for that database.
- The user account installing Octopus must be a member of the db_owner role for that database.The account the Octopus Deploy the Tax Balance windows server process runs under (by default, the
- 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.
- Configure database connection by providing a proper connection string. Use
appSettings.json
file or an enviroment variableConnectionString__SmartTaxBalanceDatabase
...