any one having these issue with IIS6.0 and MS SQL 2000 on windows 2003 ?

Hi guys , been experiencing these problems and cant find a fix no matter what, over at expert-exchange no one seems to how to fix this either

did a through search on google and found that many people also experience similar problems like me , here is one particular post from webservertalk that is exactly like me:

Cut and paste text from there :
http://www.webservertalk.com/post948220.html


We have a classic ASP application which runs fine on NT Server, W2K Server a
nd with SQL7.0 and SQL 2000.

However, we are having problems with IIS6.0 and Windows 2003 Server when con
necting to a second Windows 2003 Server running SQL 2000 Server. IIS6.0 and
SQL on the same server works fine.

We see intermittent connection problems resulting in:
Microsoft OLE DB Provider for SQL Server error '80004005'

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

We have tried everything we have found trawling the web and still have no id
ea what is causing it.

One ASP script in particular that simply updates a table, fails most of the
time but does VERY rarely run successfully. The same script NEVER failed un
der NT/SQL7.0 or W2K/SQL2000.

We have increased timeout settings in IIS and the ASP scripts themselves. W
e have changed the OLEDB connection to reference the SQL Server IP address i
nstead of its name but nothing tried has made any difference.

Any suggestions would be gratefully received!

 

 

 

 

Top