TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins. You need to write a distributed query that joins the data on SQL1 with the data on SQL2.<br /> What should you do?()
A、Ensure that both SQL1 and SQL2 use the same login name as the security context foreach server.
B、Configure SQL2 as a remote server. Write the query on SQL1.
C、Configure SQL2 as a linked server to impersonate the remote login.
D、Configure SQL2 as a distributed server. Use pass-through authentication.