Connect to SQL server via Windows Auth

I was facing the same issue as Jerry faced when connecting IRIS to SQL server. My ODBC connection is configured to authenticate via windows authentication.

Configure IRIS ODBC connection with Windows authentication using a
 

How I fixed it for myself?

Root cause

• The SQL Server DSN was set to Windows Integrated Authentication.
• IRIS opens the ODBC connection via irisdb.exe, which runs under the IRIS Windows services’ logon account.
• My IRIS services were running as LocalSystem, so SQL saw the machine account <ORGNAME>\<ASSETID>$. SQL had no login for that identity → 18456 / 28000 “Login failed for user ‘…$’”.

I changed both IRIS services to run as a domain identity that SQL Server trusts: <WINDOWSACCOUNTUSERNAME> = <Orgname>\<Username>.

Commands used (elevated CMD):

"C:\InterSystems\IRIS\bin\iris" stop <instance> quietly "C:\InterSystems\IRIS\bin\IRISinstall.exe" setserviceusername <instance> "<YOURWINDOWSACCOUNTUSERNAME>" "<password>" "C:\InterSystems\IRIS\bin\iris" start <instance>

That utility updates:

• InterSystems IRIS Controller for <instance>
• InterSystems IRIS for <instance>
  …adds the account to IRISServices and IRIS_Instance_<instance> groups, and grants required NTFS rights.

Please let me know if there is a better way to do this.