Don't go the SID route, because they're right. You can, however, create username/passwords on the web server and the SQL Server that are identical. These would be local, not domain accounts. That is one way of getting a trusted connection. It's using pass-through authentication via NTLM.
K. Brian Kelley
@kbriankelley