Installer 10.15 | Complete Installation and Upgrade Information for Software AG Products | Installing Software AG Products On Premises | Preparing for Database Component Creation | Prepare for Database Component Creation for All RDBMSs | Set Database Options | SQL Server
 
SQL Server
Software AG recommends the following database options for your products to function properly:
ALTER DATABASE database_name SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE database_name SET READ_COMMITTED_SNAPSHOT ON;
In addition, enable Named Pipes and TCP/IP protocols using the SQL Server Configuration Manager.
By default, SQL Server uses case-insensitive collations. If you create the My webMethods Server, Integration Server, or Trading Networks database component, do not change this option from the default; My webMethods Server,Trading Networks, and Integration Server do not support case-sensitive collations.
webMethods modules are not tested for case sensitivity. Setting different collation in the database might or might not work, but it is not tested and not supported.