SQL Trusted Connections with ASP.NET

The problem arises when your SQL server and your IIS/asp.net server are on separate machines, which is a typical setup. As the ASPNET user does not exist on the SQL server you can't grant access to it. There are 4 main ways to overcome this problem