Client fails to connect to server with error: 7001: User authentication failed (Doc ID 1338514.1)

Last updated on FEBRUARY 27, 2016

Applies to:

TimesTen Data Server - Version 11.2.1.8.0 and later
Information in this document applies to any platform.

Symptoms

Setup
----------
Server= serverhost
OS User = Jane

Timesten Admin user=timesten
Database internal use=jane


sys.odbc.ini
----------------

[ServerDSN]
DataStore=/timesten/product/11.2.1/TimesTen/1121/info/serverdsn
OracleNetServiceName=oracletns
DatabaseCharacterSet=WE8MSWIN1252
PermSize=700
Connections=1000
DurableCommits=1

[clientDSN]
Description=TimesTen Server
TTC_Server=serverhost
TTC_Server_DSN=serverDSN
TCP_PORT=53400



sys.ttconnect.ini
-------------------

[serverhost]
Description=TimesTen Server
Network_Address=123.456.789.00
TCP_PORT=53400





As OS user Jane:

%ttIsqlCS clientDSN

Copyright (c) 1996-2011, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.

connect "DSN=clientDSN";
7001: User authentication failed
The command failed.
Done.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms