I'm confused... What are you using to log into SQL Server and what are you using for the linked server creds? Also, see this: http://technet.microsoft.com/en-us/library/ms189580%28v=sql.105%29.aspx You need these requirements met for impersonation.