Configure IRIS ODBC connection with Windows authentication using a specified domain account rather than default IRIS server account
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:
.png)
and user (PROD\test) in the SQL Gateway connection
.png)
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?
Comments
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
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.