I have narrowed this issue down to Windows Server 2003 not allowing my
web application to connect to the SQL 2000 DB.

I have an ASP.NET web application running on my machine that is
connecting to SQL 2000 server that lives on Windows Server 2003
machine. The connection will not work from my web application to the
database.

The connection does work from my machine through query analyzer and
also from a .NET desktop application.


Is there a setting on Windows Server 2003 that blocks connections to
SQL Server that are initiated from a web application?


Thank you,
Josh

On Jun 28, 11:34*am, cardinalb...@gmail.com wrote:
As a follow up, this is occuring from any web application trying to
access the server. The failing web apps include our public site, web
service and Intranet. As I stated before, desktop applications can
access the database, just not web apps. I thought it might be IIS
security so I set the security on IIS to use the domain admin account,
and the connection is still failing. Any ideas or help would be
spectacular.

On Jun 28, 3:12*pm, cardinalb...@gmail.com wrote:
It's working now. I had to install SQL 2000 SP4