Create linked server using Windows Authentication problem RRS feed

  • Question

  • Hi,

    I have two SQL Server machines - RPTPROD and DATAPROD.

    I wanted to create a linked server from RPTPROD pointing to DATAPROD using Windows Authentication.  When I tried to create this linked server, I keep getting this error "Login failed for user 'NT AUTHORITY\ANNOYMOUS LOGON' (Microsoft SQL Server, Error: 18456)".  On the "Secruity" page, I chose "Be made using the login's current security context".   I'm sysadmin on both SQL Server machines.  

    Can someone tell me what I'm missing?

    Thank you

    Wednesday, September 9, 2015 6:26 PM


All replies