trouble linking servers

Amien90 used Ask the Experts™
i have a SQL in database engine .. it has a windows authen and works... now i want to add this server as a linked server

going to linked server --> new server.. then choose SQL server and fill in the SQL servername ... but what do i fill in at the security tab?

Thanks in advanced
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chris LuttrellSenior Database Architect

that depends on how you want security to work?  If you want all users to only be able to use the linked server if their current credentials are valid on both databases, use the "Be made using the login's current security context" option.  If you want to create a link that will work on the linked server even if the current user does not have access to it, you have to use the last option, "Be made using this security context:" and provide a valid remote login/pw that has access to the remote db.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial