You are here: Before You Start > Prerequisites > SQL Server requirements

SQL Server requirements for Promodag Reports Enterprise edition

Supported versions

Promodag Reports supports all editions of Microsoft SQL Server from SQL Server 2008 to SQL Server 2022.

SQL Server Express (2008 to 2022) may be used with Promodag Reports Enterprise edition; however, database size is limited depending on the version (10 GB for SQL Server 2008 R2/2022 Express and 4 GB for SQL Server 2008 Express).

Recommendations

We recommend the following specifications:

See also: Using Promodag Reports and Microsoft SQL Server.

Permissions

The Promodag account must have been granted the db_owner role on the Promodag Reports database. It must also have the public and db_datareader roles on the TEMPDB database.

The ability to create databases requires specific SQL permissions (CREATE DATABASE).

Data retention strategies

We recommend that you use one of the following data retention strategies: