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
os_authent_prefix parameters are set by default.
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.
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.
Run dialog box from the
Open text box, type
regedit and then click
Registry Editor dialog box opens.
In the path
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
Double-click the string value you just created.
Edit String dialog box opens.
Value data text box, type
TRUE and then click