Thanks for the repsonses, will get it working as soon as I get back to it!

Thanks, I will try that.

Have a look at one of these sites that may be able to give you a clue

http://support.microsoft.com/default.aspx/kb/310834

http://support.microsoft.com/kb/811052

Using QA I can run queries to the remote server, The remote server is set for both types of authentication.

Brian, thanks for the pointers! I will read up on it.

I have in the mean time I tried a different tack using linked servers.

Executing the following

EXEC sp_addlinkedserver

   @server=LINKEDSERVER,

  ...

I need to do the same thing, I have linked servers but still get "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."

Any ideas?

Would you be able to give some pointers as to how to set up the delegation? Our production environment is active directory, and we also have a separate test/development environment that I...