Microsoft
70-519 · Question #168
An ASP.NET Web application stores data in a Microsoft SQL Server database that runs on a separate server. The company requires all database access to be performed under the identity of the user that…
The correct answer is C. Configure the Web application for constrained delegation. See the full explanation below for the reasoning.
Question
An ASP.NET Web application stores data in a Microsoft SQL Server database that runs on a separate server. The company requires all database access to be performed under the identity of the user that is connected to the application. The Web application uses integrated security in the database string. During testing, the Web application is unable to authenticate to the database as the connected user. You need to design an authentication strategy. Which approach should you recommend?
Options
- ARun the Web application under the System account.
- BRun the Web application under the Network Service account.
- CConfigure the Web application for constrained delegation.
- DSet the identity element of the Web application configuration to impersonate="true'.
How the community answered
(21 responses)- A5% (1)
- B14% (3)
- C76% (16)
- D5% (1)
Community Discussion
No community discussion yet for this question.