Tealeaf requires Microsoft SQL Server Standard and Enterprise editions, 32-bit or 64-bit. Tealeaf supports the following versions.
- SQL Server 2019
- SQL Server 2017
- SQL Server 2016
- SQL Server 2014
- SQL Server 2012 (Version R2 recommended.)
Tealeaf requires that all CX databases be stored on a single SQL Server instance.
Tealeaf does not officially support multiple instances of Tealeaf using a single SQL Server instance. For example, installing Dev and Prod databases into the same SQL Server instance can cause unanticipated conflicts in the Tealeaf components referencing the databases.
If your SQL Server installation uses dynamic ports, additional configuration is required before installing or upgrading the Tealeaf databases.
The Database Manager supports the use of UNC paths to install or modify Tealeaf databases on network locations. There is a known issue with SQL Server supporting UNC paths. For more information about the required configuration changes, see http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvcs/thread/97479a6d-9630-4510-9994-a6cd96c5840d/.
The database server can be the same server as the Portal Server. You can also install the database server on a remote server that can be accessed by the Portal Server.
If you install Tealeaf cxConnect for Data Analysis, a local SQL instance is strongly recommended for the Tealeaf cxConnect for Data Analysis database.
Tealeaf requires 64-bit servers for all Windows-based servers hosting Tealeaf software. If your Tealeaf databases are hosted on a server that also hosts other Tealeaf software, such as the Reporting Server, you can use a supported 32-bit version of SQL Server. However, Acoustic recommends using the 64-bit version of SQL Server.