Windows Terminal Server - Oracle Logon Problem
Posted on 2009-07-15
I have a Windows 2003 R2 server setup as an application terminal server. I am able to connect to a remote Oracle DB as an administrator but not with a user in the "Users" group. Also, if I establish a connection to the Oracle server as an administrator and then open another terminal server session with a "User" account I can establish a connection to the Oracle server. If I disconnect the administrator session I loose the user session as well.
I am using Oracle 10g drivers on the server. I setup a packet capture and do not even see any packets leaving the server when the logon fails. The Oracle logon error is: Window Title: Connection Error - "Error on Connection to Oracle Database: - 2147467259?"
When the logon fails I get a Windows Security Event ID: 577, Type: Failure Aud, Category: Privilege Use. In the Description under Privileges it indicates "SeCreateGlobalPrivilege".
It appears Windows/Oracle cannot make a new network connection out of the server as a User. I do not have the Windows firewall on. I have an X-Windows Client on this same server that works fine and it opens and closes ports.
Thanks in advance!!!