Cannot connect to DB on Windows Server 2003 through Web Application

  • Thread starter Thread starter cardinalbean@gmail.com
  • Start date Start date
C

cardinalbean@gmail.com

Guest
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
 
Re: Cannot connect to DB on Windows Server 2003 through WebApplication

Re: Cannot connect to DB on Windows Server 2003 through WebApplication

On Jun 28, 11:34 am, cardinalb...@gmail.com wrote:
> 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

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.
 
Re: Cannot connect to DB on Windows Server 2003 through WebApplication

Re: Cannot connect to DB on Windows Server 2003 through WebApplication

On Jun 28, 3:12 pm, cardinalb...@gmail.com wrote:
> On Jun 28, 11:34 am, cardinalb...@gmail.com wrote:
>
>
>
>
>
> > 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
>
> 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.- Hide quoted text -
>
> - Show quoted text -

It's working now. I had to install SQL 2000 SP4
 
Back
Top