You are adding new capabilities to an ASP.NET web site. The site currently connects to a Microsoft SQL Server database by using the credentials of the CONTOSO\AppIdentity account, which has been granted access to only objects within the database. The application requires the following implementation:

Database objects that support ASP.NET roles must be added to the

existing database.

The Contoso\AppIdentity user must be granted only the minimum

privileges that are required to support all features of ASP.NET roles. You need to add the ASP.NET roles support. Which two actions should you perform? (Each correct answer presents part of the complete solution. Choose two.)

Question

You are adding new capabilities to an ASP.NET web site. The site currently connects to a Microsoft SQL Server database by using the credentials of the CONTOSO\AppIdentity account, which has been granted access to only objects within the database. The application requires the following implementation:

Database objects that support ASP.NET roles must be added to the

existing database.

The Contoso\AppIdentity user must be granted only the minimum

privileges that are required to support all features of ASP.NET roles. You need to add the ASP.NET roles support. Which two actions should you perform? (Each correct answer presents part of the complete solution. Choose two.)

Accepted Answer

A. Use the aspnet_regsql tool. C. Add the CONTOSO\AppIdentity user to the asp_Roles_FullAccess database role.

Answer

B. Use the aspnet_regiis tool.

Answer

D. Add the CONTOSO\AppIdentity user to the db_accessadmin database role.

You are adding new capabilities to an ASP.NET web site. The site currently connects to a Microsoft SQL Server database by using the credentials of the CONTOSO\AppIdentity account, which has been…

Question

Options

How the community answered

Community Discussion