You create an ASP.NET application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
To access a Microsoft SQL Server database, the application reads the following connection string from the Web.config file.
Server=SQL1;Database=Contoso;Integrated Security=SSPI;
The application is configured to use the Microsoft Internet Information Services (IIS) anonymous authentication.
You deploy the application to a production server that hosts several corporate ASP.NET applications.
You discover that database authentication fails on the production server. You need to ensure that the application can connect to the database.
You also need to ensure that no additional applications are granted access to the database.
What should you do?
A.
Grant the ASP.NET worker process user account access to the database.
B.
Grant the IIS anonymous user account access to the database.
C.
Create a SQL login for the application and grant the login access to the database. Modify the connection string to use this login.
D.
Replace the connection string with the following one.
Server=SQL1;Database=Contoso;Trusted_Connection=True;