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