title: Cannot get IIS 8 to properly authenticate to SQL Server 2012
body: <p>I am running IIS 8 on a Windows 8.1 home premium machine. I'm trying to publish for my home network an MVC application that logs in to SQL Server (2012 Developer Edition) on the same machine.The SQL Server is set up to use Windows Authentication. </p>
  
  <p>The published (to the local file system) MVC application works fine when used from Visual Studio 2013. When ran via IIS, it connects to the home page, but crashes the moment data is accessed with the message "Login failed for user 'WORKGROUP[my home machine]"</p>
  
  <p>Can I get there from here? After research, I see that I <strong>cannot set</strong> the Authentication for IIS to Windows Authentication for a Home Premium machine (option is not there, only Anonymous, ASP.NET Impersonation and Forms Authentication are there and I could make none work). So what should I do? Change authentication on SQL Server? It should be so easy--both Web and Sql Servers are on the same machine! Any/all ideas very welcome! </p>