

You will also need to change the account in SQL Server Configuration Manager.

You will need to configure the SQL Server service to run under Network Service as it has the necessary permissions According to this article it is also possible to grant the permissions to create SPNs to a service account. We suspect you might have the following messages when SQL Server starts (you can see the logs in SSMS under Management SQL Server Logs ). By default, the service runs under accounts that lack the required permissions.

Here are the steps to configure your SQL Server to allow your Protected Users to connect to the Database using the Integrated Security authentication method.Īccording to Microsoft Protected Users blocks the use of NTLM hashes It is however possible to configure SQL Server to also use Kerberos for Integrated Security The good news is that this is supported out-of-the-box by Remote Desktop Manager.įor SQL Server to support Kerberos authentication, SPNs need to be created. Configure SQL Server for Protected Users with Integrated Security
