You are designing an ASP.NET Web application that stores data in a Microsoft SQL Server 2008 database on
a remote server. You must meet the following requirements:
– Ensure that users actions can be traced on each server by using the security audit log.
– Minimize the risk of server components executing in the user s context.
You need to recommend an approach for accessing thedatabase.
What should you recommend?
A.
Use Basic authentication and impersonation to configure a trusted subsystem between servers.
B.
Use Basic authentication and set the Integrated Security property of the SQL Server connection string to
SSPI.
C.
Use Windows authentication and impersonation to configure constrained delegation between servers.
D. Use Windows authentication and set the Trusted Connection property of the SQL Server connection string
to true.