Using the MSOLEDBSQL database driver with WebMarshal

This article applies to:

• WebMarshal 7.1 and above

Question:

• How can I configure WebMarshal to use the MSOLEDBSQL driver?
• How can I connect to a SQL server that requires TLSv1.2 connectivity?

Procedure:

By default, WebMarshal uses the SQLOLEDB database provider. This provider does not work with TLS version 1.2.

To allow WebMarshal to use a logging database on a SQL server that requires TLS 1.2 connectivity, add an attribute entry in the WebMarshal Array Manager Configuration file (WMArrayMgr.config.xml) as follows:

<WebMarshal>
   <ArrayManager>
      <Config>
         <DB DatabaseProvider="MSOLEDBSQL;DataTypeCompatibility=80" />
      </Config>
   </ArrayManager>
</WebMarshal>

To apply the change, restart the Array Manager service.

Notes:

• The DataTypeCompatibility parameter is required to ensure that some insertions are correctly performed.
• For more information about editing XML documents, see Knowledge Base article Q12705.