I have an almost identical setup, ASP.NET to MSDE2K. I was successful using this article:
http://support.microsoft.com/?kbid=872905FWIW my app stores an attachment string (using Integrated Security) as follows:
Application["strDSN"] = "server=ABEAST\\MSDE2K_1;Integrated Security=SSPI;database=CEQM";
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up