Cannot connect to DB on Windows Server 2003 through Web Application

[Guest cardinalbean@gmail.com]

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

[Guest cardinalbean@gmail.com]

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.

[Guest cardinalbean@gmail.com]

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