SQLServer 2005, Linked Server, authentication


  • Hi all!!!

    I have the following problem:

    I used JTDS to connect to SQL Server 2005 SP1(with Windows Authentication) from a Tomcat DataSource, using your usefull ntlmauth.dll, so I can use Users from Active Directory.
    All is ok until I must call a Stored procedure that excecute queries from a linked server table. 
    I have the following exception message "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'"

    I make a lot of test, I make a Java main program invoking the sotred procedure that excecute queries on linked server using JTDS and then using Microsoft SQL Server 2005 JDBC Driver 1.2(April 2007)sqljdbc.jar and Ihave the same problem, but if we use the bridge JDBC-ODBC all works OK.

    Please help!!



    Wednesday, June 20, 2007 2:18 PM


All replies