>I can do anything with the database from EM, QA, or even my .NET IDE Server Explorer. It's just when I change the sever name in :
>string strConnection = "SERVER=STEPHEN-LAPTOP;Trusted_Connection=Yes ";
>to
>string strConnection = "SERVER=CHDIIS;Trusted_Connection=Yes ";
>it fails with the error that is this subject.

I would guess this is because when you use EM, QA, or .NET IDE you are connecting under one user name (the one that you logged on with) that is in fact trusted. When your app runs is running under *another* user name that is not trusted (perhaps is running under IUSR_xxxxxx)