Trouble connecting to SQL Server with ASP !?!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: somanybugssolittletimetofixthem (fixinbugzrus_at_zapembugs.com)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 08:45:47 -0700

I have to write an ASP web application against a SQL server database. The network guys set me up to create web pages on the server (IIS) and created an ODBC connection. However, I cant connect to SQL server and read any data using the System DSN. I get a generic SQL server error complaining about NT authorization. Do I need to pass a SQL server userid and password (I dont have one!). Is there any other SQL server setup needed for web access? Have spent several days struggling with this. No-one knows anything about web applications with SQL server here.