Post reply

SQL 2005 linked server connection error

  • April 17, 2008 at 7:11 am

    #69922

    Hi,

    I have created a linked server B on my local SQL Server A. Both the SQL servers are 2005 versions. When I try to execute a procedure

    Exec [Server A].[DBName].[dbo].SpName @inputXML

    I get the following error.

    Login failed for user 'FAREAST\v-ashjab'. The user is not associated with a trusted SQL Server connection.

    OR

    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

    The linked server which I have created has the following settings (Please see attached image file).

    However I am able to login to the remote server using management studio and also run the procedure.

    Could someone help me fix the problem.

  • April 22, 2008 at 7:08 pm

    #805836

    try

    http://support.microsoft.com/kb/925001

  • April 24, 2008 at 9:14 pm

    #806968

    Actually the KB article did not help. It says a higher version of the patch already exists. I refferred several articles. Most of them say something about Keebros integration with SQL Server and some double hop....I really do not understand what double hop mean. Can someone help me resolve this issue.

    Thank you,

    Ashok Jebraj

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply