Error 18452: Login Failed for user '(null)'. Reason: Not associated with a trusted SQL Server Option.

Hello,
Was wondering if i can get some assistance with the above error msg?

Here's the details:
I am trying to link to a server BBB from server AAA. When I am local on server AAA all works fine. I am using Windows Authentication.
I am accessing server AAA from my desktop. The problem is: if i go to the linked servers option & try to view server BBB i get the above error msg. I am setup with Windows Aut... on both servers. Can't figure out why.
Your help will be much appreciated!



Thanks!
Nigel

Your credentials are obviously not being passed from AAA -> BBB. You need to look up 'delegation' in BOL - there's a good article entitled 'Security Account Delegation' (you can find it from the index under 'security accounts, delegation'). This article explains all the conditions needed for delegation to work.

If you can't get all these conditions set up then you'll need to create a SQL login on sever BBB and map your windows login to that SQL login (see 'linked servers, login' in BOL).

hth
Phil

Thanks for your help 'pgtips'! i just went ahead & created an SQL Login. Simplest solution.

Thanks!
Nigel