IIS 部署站点上的 Ingres 连接
我有一个 .net 2.0 应用程序托管在 IIS 上，它连接到 Ingres DB。 该连接使用带有 ODBC 驱动程序的 iBatis 连接到受安装密码保护的 ingres 数据库。
由于某种原因，当我调试代码时，一切都运行良好。 它建立连接没有任何问题。 但是，当我尝试在本地 IIS 上托管该站点时，ingres 返回此错误，
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.
我想知道为什么安装密码在我的调试会话中可以正常工作，并拒绝在 IIS 后面连接？ IIS 是否使用与我的计算机名称不同的其他“名称”来与安装密码建立连接？
I have a .net 2.0 app being hosted on IIS, that connects to a Ingres DB. The connection uses iBatis with an ODBC driver to connect to an ingres database being protected behind an installation password.
For some reason, when I'm debugging my code, everything runs fine. It establishes the connection without any problems. However, when I try to host the site on my local IIS, ingres comes back 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'm wondering why the installation password would work fine against my debug session, and refuse to connect behind IIS? Does IIS use a different 'name' that isn't my computer name to establish a connection with the installation password?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
连接被拒绝，因为目标服务器不知道用户尝试连接或尚未添加该用户。 检查本地 IIS 实例的进程所有者是否是有效的 ingress 用户。 IIRC 帐户名通常类似于 IUSR_MACHINENAME，其中 MACHINENAME 是 IIS 机器的主机名。 在服务器上使用以下 SQL 添加用户帐户：
The connection is being rejected because the target server is not aware of the user trying to connect or that user has not been added. Check to see if the process owner of your local IIS instance is a valid ingres user. IIRC the account name is normally something like IUSR_MACHINENAME, where MACHINENAME is the hostname of your IIS box. Add the user account using the following SQL on the server: