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

ARMS
12/2/2005 11:41:03 AM

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_<computername>. 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.
--

Ron Hinds
12/14/2005 1:36:58 PM

Try adding a SQL Server UID and PWD to the connection string.

[quoted text, click to view]

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