IIS to Sql Server Login Failed when not on same domain

Thats happened a few time already (over the past few years). IIS likes to know who you are before it lets you talk to SQL server. So a nice blog here if you are connecting to a Sql Server db from IIS and the two machines are not under the same AD domain.

http://beyondthispoint.blogspot.com/2006/04/setting-up-iis6-application-pool.html

Do the steps, it works! This post is like an extended book mark!