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.

Last Modified 6/19/2018.
https://support.trustwave.com/kb/KnowledgebaseArticle21019.aspx