You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance. You need to identify the most likely cause of the connection issues. What should you do first?（）

单项选择题YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.AuserinyourcompanynamedEricwritesmanyadhocqueriesagainstthecompanydatabases.ErichasaccesstotheCustomerdatabaseonSQL1.HedoesnothaveaccesstotheSalesdatabaseonSQL2.YouneedtoensurethatEriccanwritequeriesthatjoininformationfrombothservers.Whatshouldyoudofirst?（）

A.Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation. 
B.Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins. 
C.Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name. 
D.Instruct Eric to specify SQL Server object names by using four-part notation. 

单项选择题Application developers in your company create an assembly that contains a CLR function. This CLR function reads data from a spreadsheet, performs some calculations, and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set.  Which permission set should you use? （）

A. Default 
B. SAFE 
C. EXTERNAL_ACCESS 
D. UNSAFE

多项选择题YouarepreparingforanewinstallationofSQLServer2005.Youneedtoselecttheprotocolsthatclientcomputersmightusetoconnecttotheserver.Whichtwoprotocolscanyouusetoachievethisgoal?（）

A. Named Pipes 
B. TCP/IP 
C. Shared Memory 
D. Virtual Interface Adapter (VIA) 
E. Multiprotocol