SXI Forum

StephanB

Member

Registered: 21-11-2018

Posts: 40

XLayer MSSQL Connector using Server Authentication

When using the Connection type MSSQL in the Connector, connecting to a MSSQL database server using SQL Server Authentication and you get the following ERROR:

ERROR - Connection failed for Connector 'MyLocal_MSSQL' to server 'localhost' for DataBase 'SomeDB'. Error '"encrypt" property is set to "true" and "trustServerCertificate" property is set to "false" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption ......

Include the following properties in the Connector:
1. Property: encrypt
2. Property: trustServerCertificate

Here is an example:

<Connector id="MyLocal_MSSQL">
  <Connection xsi:type="MSSQL">
     <RetryDelay>30</RetryDelay>
     <Server>localhost</Server>
     <User>User</User>
     <Password>Password</Password>
     <DBName>SomeDB</DBName>
     <Properties>
       <Property name="encrypt" value="false"/>
       <Property name="trustServerCertificate" value="true"/>
     </Properties>
     <Port>1433</Port>
  </Connection>
  <ReturnCodes>
    <Success />
    <DefaultError type="Non-Recoverable">
       <ExceptionCodes>
         <Code>^.*I/O Error.*$</Code>
         <Code>^.*Timeout occurred.*$</Code>
         <Code>.+Read timed out.+</Code>
         <Code>.*Invalid state.+</Code>
         <Code>.*SHUTDOWN is in progress.+</Code>
        </ExceptionCodes>
    </DefaultError>
  </ReturnCodes>
</Connector>

Last edited by StephanB (13-01-2026 08:56:04)