Installer 10.5 | 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 database component, do not change this option from the default; My webMethods Server does not support case-sensitive collations.