I also think the problem is not at the IIS level. When I test the connection from IIS, it works from there, either with a custom authentication or from the application pool authentication.
When you create a new database and want to use it on a new Web site, do you usually have to do something at the database level? I will have to revise my notes.