Webmaster Forum / ASP / Database Access / November 2006

I have a MS SQL 2000 sp4 db.  IIS on a seperate server running win
2003.  I am trying to use integrated windows authentication but it
keeps failing.  IUSR_ is turned off.  I can connect to the db using
basic authentication but as soon as I turn on windows and off basic I
get

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

I have added the site to the trusted sites in IE and no luck.  I read
somewhere today on a ms site that windows authentication couldn't be
used but I thought this was what it's for.  What am I missing any links
to get this working would be appreciated.

I am using a dsnless connection

Dim cst, conn
   cst = "Provider=SQLOLEDB;" & _
       "Data Source=RiCSQL;" & _
       "Initial Catalog=InstrumentScheduling;" & _
       "Integrated Security=SSPI"

   set conn = CreateObject("ADODB.Connection")
   conn.open cst