webMethods Product Suite  | Complete Installation and Upgrade Information for Software AG Products | Installing Software AG Products | Preparing for Database Component Creation | Database User and Storage, and Database Settings | Set Database Options | SQL Server
 
SQL Server
The following database options are required 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.
Copyright © 2007-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.