If you are using a Trusted Connection in the connection string to a database and you get the following error:

Login failed for user (null).
Reason: Not associated with a trusted SQL Server connection.
Try adding this to your Web.Config File:

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