Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000

Hi
I,m new to Server 2003 and I'm moving an ASP website to it.
This is what I have; an basic ASP web site that connects to a "SQL server
2000" database on Windows XP box, using IIS.
Now I have moved the site to Server 2003, on IIS 6, but I'm still using "SQL
Server 2000"
However I can't get the website to connect to the database. this is the
error I'm am geting

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

/uoc/include/Common.asp, line 100

In IIS 6.0, under the Directory Security tab, I'm using anonymous access,
and it uses the user IUSR_. Also I have Integrated Windows
authentication checked off. Is there some security setting that I need to
set, or do I need to give more access to the "IUSR" user? (oh and I also
confirmed that SQL server is using SQL Server and Windows Authentication )

Thanks for any help you can give me.
--
http://spaces.msn.com/members/anthonyarms/

Re: Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000

ARMS wrote:
> Hi
> I,m new to Server 2003 and I'm moving an ASP website to it.
> This is what I have; an basic ASP web site that connects to a "SQL
> server 2000" database on Windows XP box, using IIS.
> Now I have moved the site to Server 2003, on IIS 6, but I'm still
> using "SQL Server 2000"
> However I can't get the website to connect to the database. this is
> the error I'm am geting
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
>
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.
>
> /uoc/include/Common.asp, line 100
>
> In IIS 6.0, under the Directory Security tab, I'm using anonymous
> access, and it uses the user IUSR_. Also I have
> Integrated Windows authentication checked off. Is there some security
> setting that I need to set, or do I need to give more access to the
> "IUSR" user? (oh and I also confirmed that SQL server is using SQL
> Server and Windows Authentication )
>

I have seen reports in this ng that the latest SQL Server SP fixes this
problem.

Bob Barrows
--
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.

Re: Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000

Thanks; that worked.
--
http://spaces.msn.com/members/anthonyarms/


"Bob Barrows [MVP]" wrote:

> ARMS wrote:
> > Hi
> > I,m new to Server 2003 and I'm moving an ASP website to it.
> > This is what I have; an basic ASP web site that connects to a "SQL
> > server 2000" database on Windows XP box, using IIS.
> > Now I have moved the site to Server 2003, on IIS 6, but I'm still
> > using "SQL Server 2000"
> > However I can't get the website to connect to the database. this is
> > the error I'm am geting
> >
> > Microsoft OLE DB Provider for SQL Server error '80004005'
> >
> > [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> > access denied.
> >
> > /uoc/include/Common.asp, line 100
> >
> > In IIS 6.0, under the Directory Security tab, I'm using anonymous
> > access, and it uses the user IUSR_. Also I have
> > Integrated Windows authentication checked off. Is there some security
> > setting that I need to set, or do I need to give more access to the
> > "IUSR" user? (oh and I also confirmed that SQL server is using SQL
> > Server and Windows Authentication )
> >
>
> I have seen reports in this ng that the latest SQL Server SP fixes this
> problem.
>
> Bob Barrows
> --
> 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.
>
>
>