Oracle

If you receive an unexpected error occurred message when defining an Oracle data source, security permissions may not have been properly set when the Oracle client was installed on Windows with NTFS. The result of this is that content of the ORACLE_HOME directory is not visible to Authenticated Users on the machine; this causes an error while the System.Data.OracleClient is communicating with the Oracle Connectivity software from ASP.NET using Authenticated User privileges.

To fix the problem you must give the Authenticated Users group privilege to the Oracle Home directory.

1. Log on to Windows as a user with administrator privileges.
2. Start Window Explorer and go to the ORACLE_HOME folder.
3. Right-click the ORACLE_HOME folder and select Properties.
4. Click the Security tab.
5. In the Name list, click Authenticated Users.
6. In the Allow column, click the Read and Execute check box to deselect it.
7. In the Allow column, select the Read and Execute check box.
8. Click the Advanced button and in the Permission Entries verify that Authenticated Users are listed with Read & Execute permission, and Apply To = This folder, subfolders and files.
9. Click OK until you close out all of the security properties windows.
10. Reboot the computer.