Exam 70-413 topic 1 question 107 discussion

Actual exam question from Microsoft's 70-413

Question #: 107
Topic #: 1

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

Show Suggested Answer

Suggested Answer: B 🗳️
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

by SummerSlumber at Oct. 3, 2020, 8:28 a.m.

Comments

Submit Cancel

SummerSlumber

4 years, 8 months ago

You need constrained delegation for this, not NTLM

upvoted 1 times

...