Dear Team, when I try to connect to oracle database located at(192.168.9.104) from SAS Management console (Located at 192.168.9.38) I am getting the error "Application could not logon to server", please find the attachment for error screenshot. Error Message Unknown User Name. The application could not log on to the server "sascompute:8591". The user ID "ARGSRI_FINAL" or the password is incorrect. I can connect to my database from SQL Prompt (please find the screenshot attached), but cannot connect from Management console. Please let me know where I am going wrong. here is my LIBNAME LIBNAME LIBREF ORACLE PATH=ARGPHY SCHEMA=ARGSRI_FINAL USER=ARGSRI_FINAL PASSWORD="{sas002}E7459716560D1F38028B623747D2EFA0063235DB" ; TNSPING C:\Users\Administrator>tnsping ARGPHY TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-APR-2 018 13:05:53 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: D:\app\Administrator\product\11.2.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.12.26)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ARGPHY))) OK (20 msec) C:\Users\Administrator> where ARGPHY is tns entry name. Thank you.
... View more