I want to connect to SQL Server using a domain account from a web host that is NOT in the domain. This is a plain vanilla ASP.NET web app. This off-domain site hits Reporting Services using domain credentials and I don't know why this isn't allowed for SQL connections.

We have a lot of internal apps (win form and web form) and this is the last one to convert to integrated security so we can manage permissions across the board via AD, but if I have to do it in SQL, then I can accept defeat.

Has anyone figured out how to do this or is it just not possible?