You are not logged in.
When trying to connect to a MSSQL database server that uses Windows Authentication please remember the following:
Include the following property: useNTLMv2
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.
Offline
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>
Offline