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

This is Interesting: Free IT Magazines  
Home > Archive > Site Server General > December 2005 > Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

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

2005-12-02, 5: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/
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com