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.