Issue
What authentication does Sigma ODBC use?
Environment
ODBC
Authentication
Cause
There is a requirement for two Sigma servers to pass data to a dedicated MS SQL Server 2008 R2 machine. But there are issues with the authentication.
Resolution
Sigma ODBC does not support authentication.
When configuration the SQL database, NT AUTHORITY/ANONYMOUS must be used, Mixed Mode must not be selected.
The screen shot below shows part of the SQL Server installation process, with Windows Authentication Mode selected.
