HSODBC a Oracle database link with SQLServer DBlink fails Credential retrieval failed Lost RPC connection to remote Agent

In ODBC Administrator did u try "Test connection"?? Did it succeed??
Please let me know the Authentication service setup in SQLNET.ORA..

Now you are on to something:
Oracle metalink came and told me to comment out the line
SQLNET.AUTHENTICATION_SERVICES= (NTS)
## SQLNET.AUTHENTICATION_SERVICES= (NTS)
After I did this the DBlink worked.Great only now my sys/  login doesnot work nor does my RMAN /@DB  connection.
What gan I do to get the sys connection working again.
Thank you
Chris

Yes.. I was about to tell the same thing.. U can also configure it to (NONE).. That would also solve the problem..
OK.. Now let us come to the next problem..
I dont think Database Links should affect sys login..
From what u have explained it is only SYS login which is not working right?? Are u able to login as all other users???
Please let me know the error message displayed while attempting to login..

Thank you for your help
I can logon as anyone as long as I  put the user name and password.
But putting passwords in my automated backup scripts won;t pass Audit.

So how can I change
## SQLNET.AUTHENTICATION_SERVICES= (NTS)
to get the best of both worlds.
Below are the traces and errors that you asked for.
Thank you once again I have been working on this alot.
Chris


Also commenting out the sqlnet line
## SQLNET.AUTHENTICATION_SERVICES= (NTS)
makes my sys connections fail.
Connect sys/****@KNTACB1.T1.TEST.ISHEALTH.NET AS SYSDBA

SQL> SQL*Plus: Release 9.2.0.1.0 - Production on Sat Apr 29 14:05:11 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> Connect sys/password@DBATEST.T1.TEST.ISHEALTH.NET  AS SYSDBA
Connected.
SQL> Connect sys/****@DBATEST.T1.TEST.ISHEALTH.NET  AS SYSDBA
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> set lines 9000
SQL> Connect sys/password@DBATEST.T1.TEST.ISHEALTH.NET  AS SYSDBA
Connected.
SQL> select * from IFC_SYSTEM@SD_SANDBOX;

  SYS_SITE SYS_VERSION     SYS_OIDHIGH
---------- --------------- -----------
         1 4.5.0588.1605         57457

SQL> ## SQLNET.AUTHENTICATION_SERVICES= (NTS)
SP2-0734: unknown command beginning "# SQLNET.A..." - rest of line ignored.
SQL> select * from IFC_SYSTEM@SD_SANDBOX;

  SYS_SITE SYS_VERSION     SYS_OIDHIGH
---------- --------------- -----------
         1 4.5.0588.1605         57457

SQL> /

  SYS_SITE SYS_VERSION     SYS_OIDHIGH
---------- --------------- -----------
         1 4.5.0588.1605         57457

SQL> /

  SYS_SITE SYS_VERSION     SYS_OIDHIGH
---------- --------------- -----------
         1 4.5.0588.1605         57457

SQL> *********************************************
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> Connect sys/ora4u2c@DBATEST.T1.TEST.ISHEALTH.NET  AS SYSDBA
Connected.
SQL> set lines 9000
SQL> select * from IFC_SYSTEM@SD_SANDBOX;
select * from IFC_SYSTEM@SD_SANDBOX
                         *
ERROR at line 1:
ORA-28546: connection initialization failed, probable Net8 admin error
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(
ORA-02063: preceding 2 lines from SD_SANDBOX


SQL> ************************************************

Instance name: dbatest

Redo thread mounted by this instance: 1

Oracle process number: 30

Windows thread id: 3916, image: ORACLE.EXE


*** 2006-04-29 14:13:35.000
*** SESSION ID:(31.39924) 2006-04-29 14:13:35.000
HS:  RPC error, SendGetProduct pid, NCR code 1003
HS:  Probable error (ORA-28546) in network administration
*** 2006-04-29 14:13:35.000
*** 2006-04-29 14:13:35.000
HS:  Error ORA-28544 or 28546, probable network admin error
HS:  Lost RPC connection to remote Agent...
HS:  ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MZVMDB02)(PORT=1524)))(CONNECT_DATA=(SID=SD_SANDBOX))), NCR status = 28546
HS:  RPC error, SendGetProduct pid, NCR code 1003
HS:  Probable error (ORA-28546) in network administration
*** 2006-04-29 14:13:35.000
HS:  Error ORA-28544 or 28546, probable network admin error
HS:  Lost RPC connection to remote Agent...
HS:  ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MZVMDB02)(PORT=1524)))(CONNECT_DATA=(SID=SD_SANDBOX))), NCR status = 28546

Thank you for everyones help. I got it to work but the passwordfile is a problem.
Here is my final instructions to help someone else:

To connect to SQLServer from Oracle
1: I made my Oracle service account a user on my SQLServer database
2: Create an ODBC
3: Create the INIT----.ora in the hs directory
4: Modify the Listener
5: Modify the TNSNames
6: Modify the SQLNet.ora file  from (NTS) to (none)
7: Modify the parameters Global_Names = False
8: Create a DBlink
9: The sql query works
10: Now come the bad part. Modify all of your oracle maintenance script that used a password file because now they don't work because we in step 5 disabled
the password file.
11: Is there a way to be able to continue to logon using the password file???
Thank you
Chris Kelly