You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com has multiple servers in a distributed environment.
Your duties at Domain.com encompass administrating two SQL Server 2005 computers named Certkiller -DB01 and Certkiller -DB02. Every server makes use of SQL Server Authentication and they use different logins. You need to write a distributed query that joins the data on Certkiller -DB01 with the data on Certkiller -DB02.
What should you do?
A.
You should configure Certkiller -DB02 as a linked server in order to impersonate the remote login.
B.
You should configure Certkiller -DB02 as a distributed server. Then you will be able to use pass-through authentication.
C.
You should make sure that both Certkiller -DB01 and Certkiller -DB02 makes use of the same login name as the security context for each server.
D.
You should configure Certkiller -DB02 as a remote server and then write the query on Certkiller -DB01.
Explanation:
You need to define a linked server for each external data source you want to access and then configure the security context under which your distributed queries will run. You can configure the linked server to use one of the following security modes:
Self-mapping
– When a linked server is created, this mode is added for all local logins, so SQL Server tries to connect to the external data source using the current user’s login credentials. The same login and password must exist on the remote server. This is the default behavior. Delegation – This mode impersonates the Windows local credentials; the connection forwards the credentials of an authenticated Windows user to the linked server. The Windows user account and password must exist on the linked server. Remote Credentials – This mode lets you map local logins to remote logins on the external data source.