You administer a SQL Server 2008 infrastructure. You plan to design an infrastructure for a new application. The application has the following requirements:

Users can connect to an instance named SQLSERVER1.

SQLSERVER1 is linked to a server named SQLSERVER2.

SQLSERVER1 and SQLSERVER2 run on different computers.

The SQL Server instances use only Windows authentication.

You need to configure the infrastructure to ensure that the distributed queries are executed in the Windows security context of the login. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

Question

You administer a SQL Server 2008 infrastructure. You plan to design an infrastructure for a new application. The application has the following requirements:

Users can connect to an instance named SQLSERVER1.
SQLSERVER1 is linked to a server named SQLSERVER2.
SQLSERVER1 and SQLSERVER2 run on different computers.
The SQL Server instances use only Windows authentication.

You need to configure the infrastructure to ensure that the distributed queries are executed in the Windows security context of the login. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

Accepted Answer

B. Register a server principal name (SPN) for SQLSERVER1 and SQLSERVER2. D. Create a map for each SQL login from SQLSERVER1 to SQLSERVER2 and use the

Answer

A. Configure all servers to use the Shared Memory network protocol.

Answer

C. Use the local computer account as a service account for SQLSERVER1 and SQLSERVER2.

Answer

E. Ensure that the two instances use the same Windows account for the Microsoft SQL

You administer a SQL Server 2008 infrastructure. You plan to design an infrastructure for a new application. The application has the following requirements: - Users can connect to an instance named…

Question

Options

How the community answered

Community Discussion