All geek questions in one place

Ingres Connection on IIS Deployment Site

I have a .net 2.0 application hosted on IIS that connects to the Ingres database. The connection uses iBatis with the ODBC driver to connect to the ingres database, which is protected by the installation password.

For some reason, when I debug my code, everything works fine. It establishes a connection without any problems. However, when I try to host a site on my local IIS, ingres returns with this error

ERROR [5000H] [CA][Ingres ODBC Driver][Ingres]User authorization check failed.
        Your user identifier was not known to this installation.
        Contact your system manager for further assistance.
ERROR [08S01] [CA][Ingres ODBC Driver][Ingres]The connection to the server has been aborted.

I am wondering why the setup password will work fine with my debugging session and refuse to connect through IIS? Does IIS use another "name" that is not my computer name to establish a connection with the installation password?

+3
source share
1 answer

The connection is rejected because the target server does not know the user trying to connect, or this user has not been added. Verify that the process owner of your local IIS instance is a valid ingres user. The IIRC account name is usually something like IUSR_MACHINENAME, where MACHINENAME is the host name of your IIS window. Add the user account using the following SQL on the server:

echo "create user IUSR_MACHINENAME\g" | sql iidbdb
+1
source

Source: https://habr.com/ru/post/1713066/

More articles:


All Articles