12-02-05 10:51 PM
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.
--
http://spaces.msn.com/members/anthonyarms/
[ Post a follow-up to this message ]
|