windows integrated authentication

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

Re: windows integrated authentication

Mike wrote:
> 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.
>
http://www.aspfaq.com/show.asp?id=2009

Make sure you follow the links to the relevant MS KB articles/


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.