No HS to remote SQL Server Data Source using NT Authentication?
492569Mar 23 2006 — edited Nov 16 2006I am attemping to use Generic Connectivity to pull SQL Server 2000 data into 10g.
We have the DSN configured, the oracle files modified properly (we have done similar setups before), and are able to successfully tnsping the SQL Server.
However, after creating our database, when trying to execute a query against the remote source I receive the following error message:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (SQL State: 28000;
SQL Code: 18456)
ORA-02063: preceding 2 lines from IDW_LINK
As the message indicates that the error is coming from the SQL Server, I assume a connection is being established.
I remember reading postings here from a couple years back about HS not being able to connect to remote SQL Servers when NT Authentication is required. Is this still the case?
I did in fact provide to the link my "domain\username", "password" combination that has access to the sql server, but this is of course using NT Authentication.
Any ideas on why HS would be sending "NT AUTHORITY\ANONYMOUS" to the sql server? Is this still the already existing problem of no NT Auth for remote data sources?