Note: This procedure is only necessary if you use Oracle OS authentication. If you use Oracle database authentication, continue
by setting up the Oracle client.
On the server where the database is located, locate the Oracle Initialization file in the directory where Oracle was installed.
In the Oracle Initialization file, set values for the following parameters:
remote_login_passwordfile = none
remote_os_authent = true
os_authent_prefix = ““
Note: If any of the parameters and values do not exist, you must add them. In Oracle 11g, the
remote_os_authent and
os_authent_prefix parameters are set by default.
Locate the
SQLNET.ORA file in the directory where Oracle was installed.
The file is located in
ORACLE_HOME\Network\Admin directory under the main Oracle installation directory where
ORACLE_HOME is the name assigned for the Oracle home during installation.
Open
SQLNET.ORA and set the value of the following parameter as follows:
sqlnet.authentication_services = (NTS)
Note: Ensure this parameter is not commented out with a
# at the beginning of the line. You may need to add this parameter.
Access the
Run dialog box from the
Start menu.
In the
Open text box, type
regedit and then click
OK.
The
Registry Editor dialog box opens.
In the path
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEn (where
n is the number associated with the Oracle installation), right-click
HOMEn and choose
New > String Value.
A new string value appears in the right pane of the registry editor.
Replace the default name,
New Value #1 with
OSAUTH_PREFIX_DOMAIN.
Double-click the string value you just created.
The
Edit String dialog box opens.
In the
Value data text box, type
TRUE and then click
OK.