You are a database administrator of two SQL Server 2005 computers named AIOTestKing A and AIOTestKing B. You have a Microsoft .NET application that has been modified so that it now accesses a database on AIOTestKing B in addition to AIOTestKing
A.
You do not want the user application to connect directly to AIOTestKing B. You need to enable the data retrieval from AIOTestKing B while maintaining the ability to assign different permissions to different users who use the .NET application. What should you do?
B.
Change the .NET application to define a new server connection to AIOTestKing B.
C.
Configure a linked server on AIOTestKing A to point to AIOTestKing B.
D.
Change the stored procedures called by the .NET application to include the OPENXML command.
E.
Configure a linked server on AIOTestKing B to point to AIOTestKing A.
Explanation:
SQL Server lets you access external data sources from your local Transact-SQL code. 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. After you create a linked server, you can use the Transact-SQL OPENQUERY function to execute your distributed queries.