2 Posts on my first day....I need to slow down.

Note: I have an ASP.NET Web app using ADO.NET.

Ok, I finally debugged my web app running on remote server enough to find out that when it creates an ODBC.NET connection it uses this new user account named, oddly enough, "ASPNET user."

What do I need to do to allow my web app to access a server local to the application AS WELL AS access a server on other machines in the domain?

Is it something like adding ASPNET user to the SQL SERVER database or giving ASPNET more user rights(which i dont like)?

- john