We’re using IIS 7.5, SQL Server 2014, and Windows Authentication.

We’ve set up a ASP.Net MVC 5 Web project with the Kendo UI widgets and backed by a Telerik.OpenAccess data layer.

So, the other day, I moved my Telerik.OpenAccess backing database from localhost on my dev machine to our communal dev server and started getting this error:

Login failed for user ‘DOMAIN\MY_PC$’.

Source File: c:\_tfs\SourceCode\Experiments\Experiment6.Entities\EntitiesModel.cs

Turns out, that now that I am running the Web Server and the SQL Server on different boxes, I need to make this change to my web.config to allow impersonation:

<system.web>
  <identity impersonate="true" />
</system.web>

Once this was done, I could access the database properly using Windows Authentication in the web front end and Windows Authentication in the SQL Server back end.