>>>>I want to pull data from a table on SMAP001. I'm in server SMIT001. I have created a linked server to SMAP001
>>>>
>>>>I have this so far
>>>>
>>>>

>>>>	SELECT	smap001.PK5.PD.PD_IMKEY AS Item,
>>>>			Min(smap001.PK5.PD_PREF) AS MinOfPD_PREF
>>>>		FROM PD
>>>>		GROUP BY PK51PD.PD_IMKE
>>>>
>>>>
>>>>

>>>>
>>>>I'm getting "Invalid object name 'smap001.PK5.PD'."
>>>
>>>You should use full syntax to get DB:
>>>
>>>

>>>	SELECT	PD.PD_IMKEY AS Item,
>>>		Min(PD.PD_PREF) AS MinOfPD_PREF
>>>        FROM smap001.PK5.SchemaHere.PD PD
>>>	GROUP BY PD.PD_IMKE
>>>

>>
>>
>>Ok, I now get "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
>
>
>You didn't set your linked server well.
>You should set all security and logons.

How?