I'm trying to run a procedure on an MS SQLServer DB. The procedure queries tables that are on a linked server. To be able to access this linked server the procedure needs to run as a specific user. I added this (domain) user as a credential. When I run the procedure I get an error that seems to suggest the credential isn't working:



What should I do to get this working? Might it be that the credential is faulty? (it didn't show up on the 'username' drop down. I had to enter it manually) I tried it with and without local login checked.

Thanks

To use integrated authentication you need to do two things:

1. Use a Credential with "Load profile" checked
2. make sure that the SQL Connection string that you have selected is using Integrated authentication

---

Thanks, I missed the 'trusted connection' option in the connection wizard. Everything works now.