<![CDATA[SXI Forum / Windows Authentication to SQL server from Java]]> https://www.xlayer.co.za/forum/viewtopic.php?id=20 Tue, 12 Jan 2021 13:01:49 +0000 FluxBB <![CDATA[Re: Windows Authentication to SQL server from Java]]> https://www.xlayer.co.za/forum/viewtopic.php?pid=196#p196 Here is an example:

<Connector id="XlayerDB" type="DB">
      <Connection xsi:type="sxi:MSSQL">
        <sxi:Server>127.0.0.1</sxi:Server>
        <sxi:User>myuser</sxi:User>
        <sxi:Password>secret</sxi:Password>
        <sxi:RetryDelay>10</sxi:RetryDelay>
        <sxi:DBName>SomeDB</sxi:DBName>
        <sxi:Properties>
          <sxi:Property name="useNTLMv2" value="true"/>
          <sxi:Property name="domain" value="ACME"/>
        </sxi:Properties>
        <sxi:Port>1433</sxi:Port>
      </Connection>
      <sxi:ReturnCodes>
        <sxi:Success/>
        <sxi:RecoverableError>
          <sxi:Code>.+Read timed out.+</sxi:Code>
          <sxi:Code>.*Invalid state.+</sxi:Code>
          <sxi:Code>.*SHUTDOWN is in progress.+</sxi:Code>
          <sxi:Code>I/O Error: Connection reset by peer: socket write error</sxi:Code>
        </sxi:RecoverableError>
      </sxi:ReturnCodes>
    </Connector>
]]> Tue, 12 Jan 2021 13:01:49 +0000 https://www.xlayer.co.za/forum/viewtopic.php?pid=196#p196 <![CDATA[Windows Authentication to SQL server from Java]]> https://www.xlayer.co.za/forum/viewtopic.php?pid=32#p32 When trying to connect to a MSSQL database server that uses Windows Authentication please remember the following:

  1. Include the following property: useNTLMv2

  2. Include the following Domain property: domain=mydomain.local (where "mydomain.local" is the trusted windows domain of the user allowed to access the database)

These can be set in the applications configuration.

]]> Wed, 21 Nov 2018 09:07:09 +0000 https://www.xlayer.co.za/forum/viewtopic.php?pid=32#p32