Click here to get back home

Web applications cannot connect to SQL Server on new Windows 2003 R2 machine

 HomeNewsGroups | Search | About
 microsoft.public.windows.server.security    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Web applications cannot connect to SQL Server on new Windows 2003 R2 machine cardinalbean 06-28-2008
Get Chitika Premium
Posted by cardinalbean on June 28, 2008, 4:16 pm
Please log in for more thread options
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?

This is not IIS security related because I have IIS running under the
domain admin account. All web apps are now failing to connect to the
DB including our public web service, public web site and Intranet.

Desktop applications are able to connect, just not web apps

Thank you,
Josh

Posted by cardinalbean on June 29, 2008, 11:04 am
Please log in for more thread options
On Jun 28, 3:16=A0pm, 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. =A0The 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?
>
> This is not IIS security related because I have IIS running under the
> domain admin account. =A0All web apps are now failing to connect to the
> DB including our public web service, public web site and Intranet.
>
> Desktop applications are able to connect, just not web apps
>
> Thank you,
> Josh

I figured it out. I had to install SQL 2000 SP4

Similar ThreadsPosted
How to Add 'MyFile.exe' to the 'Run only allowed Windows applications', using a Script / Registry / WMI / API or whatever ? July 16, 2007, 3:24 am
can I connect to an external server using a local account? February 20, 2008, 12:45 pm
Windows 2008 CA can't issue to Windows 2003 server June 25, 2008, 11:53 am
Windows server 2003 security. How to protect against 100's of invalid logons to the server?? August 12, 2005, 5:29 pm
Windows server 2003 and Windows SBS Cost ? August 25, 2005, 11:19 pm
SP-1 to a Windows 2003 Server running SQL Server 2000 with out SP- July 5, 2005, 5:20 pm
VPN and Windows 2003 Server May 31, 2005, 11:58 pm
Windows Server 2003 R2 March 10, 2007, 10:20 am
Windows 2003 Server SP2 April 9, 2008, 5:03 pm
machine password expiration in the 2003 domain environment April 14, 2008, 10:57 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap