SQL Server Linked Server with different active directory domain credentials

Question

I have a remote database I need to create a linked server to. The problem is it's been set up with my group's functional account an not my own. The only way I can think of doing this is logging out of my personal work account and then back in with out functional account and then set up the link that way, but that is impractical.

So my question is, is there any possible way to set up a linked server using different active directory credentials on a SQL Server 2005 server?\

EDIT: Bascially I am logged in as AD_MAIN\OhioDude but I need to authenticate to the remote server using AD_MAIM\DeptGroup

Answer 1

You can change the properties of the linked server so it uses an alternate set of credentials. From SSMS if you right-click on the linked server and go to Properties -> Security, you can change how the authentication is done for the remote server. I don't know if you can specify a Windows-based login for the remote security context, but it's worth a try.