I am trying to use an Ingress driver for my DSN in ODBC. The Ingress driver is setup to use the local windows account for verification. I changed the services that were starting with administrator to the account I need CRS to use. Everything else works fine, but the database subsystem will not come up.
Below are some error messages I get:
When I update the subsystem I get this:
610: Apr 20 10:06:36.187 EDT %MIVR-SS_DB-3-UNK:Database create connection failed : SQL_ERROR_CODE = 5
SQL_STATE = S1000
611: Apr 20 10:06:36.187 EDT %MIVR-SS_DB-3-UNK:Cannot create Datasource for given DSN : DSN_NAME = db_con
612: Apr 20 10:06:36.187 EDT %MIVR-SS_DB-3-UNK:Error in checkout from DSN : DSN_NAME = db_con
613: Apr 20 10:06:36.187 EDT %MIVR-SS_DB-3-UNK:Bad connection for the given DSN : DSN_NAME = db_con
Now keep in mind if you don't know ingress, it a client that you install on the CRS server and it becomes a usable driver in ODBC. You use the driver, give it a name (when creating the DSN) and that's about all you configure. There is nowhere to specify a username/password in the setup like if I was doing a SQL server ODBC connection. Is this supported? Is there something else I need to do that I'm missing? Did I miss something when it comes to passing windows authentication? I need it to work even if no one is logged on (which is why I changed the CRS services to use another account (which is local admin) to start up with).
Can anyone help?
