Cannot open database “db1″ requested by the login. The login failed for user ‘Machine\ASPNET’

Here’s a quick breakdown of some options:
1.)  Use a user name and password in the connection string
2.)  Have the application run under a different account that has permission to access the database
3.)  Grant permission to the ASP.NET account
4.)  Consider having ASP.NET impersonate the current user
I hope this information proves helpful.
———————————————–
Try executing a query like:
exec sp_grantlogin ‘MachineName\ASPNET’
———————————————–
<identity impersonate=”true”
userName=”domain\user”
password=”password” />