Answers to Review Questions

  1. C. You can use the sp_addlinkedsrvlogin stored procedure to create or update a mapping between a login on the local instance of SQL Server and a security account on a remote server. You can use sp_addlogin to create a new SQL Server login that allows a user to connect to an instance of SQL Server by using SQL Server authentication. There are no system stored procedures named sp_addlinkedlogin or sp_addloginmapping.
  2. B.Increasing the connection timeout will give the distributed query more time to be resolved. Since only queries to the Auburn server are having timeout problems, the Auburn server is the only one that needs to have the configuration change.
  3. B,E. Windows authentication must be used on both the local server ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.