System Administration

Page tree

Versions Compared

Old Version 8

changes.mady.by.user Unknown User (beth.luby)

Saved on

compared with

New Version 9

changes.mady.by.user Unknown User (beth.luby)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Here are some of the recommendations by our developers to assist the database administrator in setting up the MS SQL server for optimized integration with 

Companyname
. 

Warning

If the MS SQL database takes part in mirroring or AlwaysOn Availability Groups, the database administrator must set the READ_COMMITTED_SNAPSHOT or "Is Read Committed Snapshot On" database option to ON or "True" before 

Companyname
 is installed.

Prerequisites

  • The TCP/IP connection must be set to a static port. See Microsoft help for more information.
  • The Microsoft Distributed Transaction Coordinator (MS DTC) service should be marked Automatic in Service Manager to make sure that it is running when the SQL Server service is started. 

...