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
Create your own database
- 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 windows server process runs under (by default, the
Local System
account) must be a member of the db_owner role for that database.
- 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
Powershell
$Env:ConnectionString__SmartTaxBalanceDatabase = "<enter connection string here>"
cmd
setx ConnectionString__SmartTaxBalanceDatabase "<enter connection string here>" /M
If it is not possible to provide a database connection with an db_owner role, please have a look at the manual database upgrade option.