Create linked server using Windows Authentication problem

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

September 9th, 2015 2:27pm

Please post the complete error for login failure with state
September 9th, 2015 3:59pm

I was trying wiht the same options couple of weeks ago and have same issue. i was trying between SQL 2005 & 2012. no DC. that was the issue.

If you want to use DOmain users make sure users have permissions first.

Other wise create SQL user and give the required permission. Then instead of using current security context use the last option where you prompt userid and password. It worked for me, that should work for you as well.

Free Windows Admin Tool Kit Click here and download it now
September 9th, 2015 8:10pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics