Configure IRIS ODBC connection with Windows authentication using a specified domain account rather than default IRIS server account

Question

Question

Jerry Wang · Apr 27, 2023

#Authentication #Databases #ODBC #InterSystems IRIS #InterSystems IRIS for Health

Hi experts

I'm trying to configure an IRIS ODBC connection with "Windows NT authentication using the network login ID". I have created the System DSN as below:

and user (PROD\test) in the SQL Gateway connection

However, as the error message suggests, IRIS is trying to connect with PROD\svc_mist, rather than PROD\test configured above.

Is there anyway to configure the ODBC connection with specified account with Windows Auth method?

Product version: IRIS 2022.1

Discussion (2)1

Log in or sign up to continue

Alexander Koblov · May 12, 2023

No. If you have Windows NT authentication enabled to connect to SQL Server then SQL Server ODBC driver uses OS user that executes irisdb.exe process. That's the same use as configured to run service IRIS.

If you'd like to use different user for authentication , then choose SQL Server authentication and specify that user and its password in SQL Gateway connection settings

1 0

score 0 · Answer 1 · 2023-05-15T01:19:39-04:00

Thanks for your reply Alex, I managed to get contact with ISC support, the OS user runs IRIS service will be the user connecting to ODBC. Although there is a way to switch user programmatically, I believe it's not a preferred solution.