I had ASP.Net configured for windows authentication using SQLExpress on the local machine and is working fine.
Now I had to move to the SQL Server 2012 located on a different machine (not the same box as IIS 7 running on Windows Server 2008 R2) and I have followed the instructions given in this link http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx
I ran the aspnet_regsql.exe tool to configure the database and then all the issues started.
1. Using the connection string as <add name="LocalSqlServer" connectionString="Data Source=[ServerName]; Initial Catalog=[DatabaseName];Integrated Security=True" providerName="System.Data.SqlClient" /> and run the app I get the error
System.Data.SqlClient.SqlException: Login failed for user 'Domain\MachineName$'
and I cannot provide access to the dat ...
Go to the complete details ...