January 6, 2011 at 6:58 am
Hi All, your help on this would be greatly appreciated. I've had this issue for a while now.
Setting up a linked server with my domain account and it throws the following error message out.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)
The network team have gone onto the server and ticked the property that states kerberos only so that the authentication should be ok for me.
Can anyone point me in the right direction, i.e is there anything i need to do more on the sql server properties etc.
Thanks in advance.
January 6, 2011 at 7:27 am
This was removed by the editor as SPAM
January 6, 2011 at 7:58 am
Thanks for your reply Stewartc. Answers to your questions below.
1.Sql Server
2.My domain login account is on both servers with sysadmin rights.
3.Be made using the logins current security context.
Hope this helps.
January 6, 2011 at 5:56 pm
Are the servers on the same domain?
January 6, 2011 at 8:38 pm
Make sure the domain account the SQL Service runs under is the same on both servers. If they are not, then make them.
Also, you may need to setup a SPN in Active Directory for the instance of SQL for both machines. You will need the setspn.exe tool from MS. Create an SPN for an instance with the port number 1433 and one without. You will need to reboot both servers.
You will need to run the commandlin using a domain account with "Domain Admins" rights.
January 7, 2011 at 7:10 am
Thanks for both your replies.
andersg98 - yes they are both on the same domain.
Warren peace - Both the sql services are the same (local system). Ill pass the next stage onto the network team as it is them who deal with that. I'll watch over them to understand what they do. Fingers crossed it works.
Thanks again! 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply