A company has a line-of-business application named Appl that runs on an internal IIS server. Appl 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.
How to: Access SQL Server Using Windows Integrated Security
https://msdn.microsoft.com/en-us/library/bsz5788z(v=vs.100).aspx