hiexam
microsoft · 70-413 · Q425 · multiple_choice · topic_1

A company has a line-of-business application named Appl that runs on an internal IIS server. Ap1l uses a SQL Server 200…

A company has a line-of-business application named Appl that runs on an internal IIS server. Ap1l uses a SQL Server 2008 database that is hosted on the same server. You move the database to a dedicated SQL Server named SQL1. Users report that they can no longer access the application by using their domain credentials. You need to ensure that users can access Appl. Solution: You configure App1 and SQL1 to use NTLM authentication. Then you restart the IIS and SQL Server services. Does this meet the goal?
  • A.Yes
  • B.No
Explanation
We would need to map the Windows Identity to a SQL Server database as well. Note: NTLM authentication is also known as integrated Windows authentication. If your application runs on a Windows-based intranet, you might be able to use Windows integrated authentication for database access. Integrated security uses the current Windows identity established on the operating system thread to access the SQL Server database. You can then map the Windows identity to a SQL Server database and permissions. Reference: How to: Access SQL Server Using Windows Integrated Security https://msdn.microsoft.com/en-us/library/bsz5788z(v=vs.100).aspx

Reference: examtopics_answer_description

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.