February 16, 2009 at 4:29 pm
I had setup all my servers with KERBEROS authentication, it works one on almost all the server except one. I had Link server setup from this server to another server htat also works fine but very often the link fails with the same old error " Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' but when i restart the sql service it again works fine.
Could any one tell me why is this weired thing happening?
February 16, 2009 at 7:40 pm
Your error and the post is almost funny because SQL Server is saying you don't have permissions in one of the Servers, to resolve in SQL Server you need to change to both SQL and Windows authentications.
Kind regards,
Gift Peddie
February 17, 2009 at 6:51 am
I am not sure why this is called funny but that is what happening with me.
I trying to know why every time the connection drops to that link server and i said if i restart the service it just works fine.
February 17, 2009 at 7:18 am
What makes it funny is KERBEROS authentication is high security yet SQL Server is saying you don't have permission to connect to one in your high security setup. You can get this error in more than one situation in your context you need to use the solution I posted, if you are in a web application you resolve it in IIS configurations. So I am not making fun of your problem but rather the issues, high security but locked out.
The reason Windows security are not relevant to SQL Server because SQL Server and all RDBMS comes with DCL(data control language).
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply