ASP can't connect to DB on new iis 6.0 install

ASP Free Forums Sponsor:

December 2nd, 2004, 02:55 PM

tpmac

Registered User

Join Date: Oct 2004

Posts: 14

Time spent in forums: < 1 sec
Reputation Power: 0

ASP can't connect to DB on new iis 6.0 install

Loaded up a new server with w2k3 and installed app center and iis 6.0. Synchronized the server and it got all of my web files from the other server fine. In "Manage Server" console, I have Internet Data Connector, ASP, ASP.NET, FP2002 extensions & SSI all enabled. I can pull up a HTML file fine and I can also pull up an asp page that does not connect to a database.

We can telnet to the port of two different db servers that we have tried to connect to.

We have entries in the hosts file for the db servers.

I rebooted one time and was able to connect to the database for about five minutes. Hit another asp page and whammo... db connection was gone again. But... the settings all appear to have stayed the same (also mathing the parent server in the app center cluster).

Any ideas what else I can check? I'm spending way too much time playing with this and this last little reboot tease is not helping my patience.

Thanks all.

December 2nd, 2004, 05:47 PM

Doug G

Grumpier Old Moderator

ASP Free God 11th Plane (10000 - 10499 posts)

Join Date: Sep 2003

Posts: 10,143

Time spent in forums: 3 Weeks 5 Days 9 h 9 m 36 sec
Reputation Power: 182

There seems to be a shortage of details here, like what kind of db are you trying to connect to, what kind of code is doing the connection, and what kind of errors you get?

__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain

December 6th, 2004, 08:01 AM

tpmac

Registered User

Join Date: Oct 2004

Posts: 14

Time spent in forums: < 1 sec
Reputation Power: 0

Trying to connect to SQL Server 2000. This is nothing new for these web servers other than we just upgraded from win2k server to win2k3 server. This particular server, rather than upgrading, we did a fresh install.

And because we are using App Center and the files all synched up when we got that running... it's using the same ASP code and connecting to the same db server as the cluster controller server that connects to the db without a problem.

Again, the weird thing is that I've seen it connect for a few minutes and then fail, but have not been able to reproduce that. And, I can telnet into the db server's port from this web server (server is in our dmz. db is inside).

I hope that helps. Thanks much for your help.

December 6th, 2004, 01:52 PM

Doug G

Grumpier Old Moderator

Join Date: Sep 2003

Posts: 10,143

Time spent in forums: 3 Weeks 5 Days 9 h 9 m 36 sec
Reputation Power: 182

I guess check the server's event logs for any clues? Maybe someone that knows clusters can jump in.

December 10th, 2004, 03:22 PM

tpmac

Registered User

Join Date: Oct 2004

Posts: 14

Time spent in forums: < 1 sec
Reputation Power: 0

Reinstalled IIS and App Center and one of our guys moved the network connection down to a different nic card (apparently there were two cards on this box) and it is now working fine. FYI.

December 10th, 2004, 08:01 PM

Doug G

Grumpier Old Moderator

Join Date: Sep 2003

Posts: 10,143

Time spent in forums: 3 Weeks 5 Days 9 h 9 m 36 sec
Reputation Power: 182

Quote:

Originally Posted by tpmac

Reinstalled IIS and App Center and one of our guys moved the network connection down to a different nic card (apparently there were two cards on this box) and it is now working fine. FYI.

I'm glad to hear that you got it going, I'm quite useless with cluster configurations

Viewing: ASP Free Forums > System Administration > Microsoft IIS > ASP can't connect to DB on new iis 6.0 install

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

Free IT White Papers!

Create the Optimal Architecture for your Critical Applications
Warburton's the largest independently owned bakery in the UK faced a number of difficult challenges in providing the most robust yet efficient IT infrastructure for their organization's success. IBM's services combined with their xSeries servers created the perfect platform for their SAP environment with sufficient flexibility, and did so in very time effective fashion.

Five Best Practices for Deploying a Successful Service-Oriented Architecture
This white paper describes the benefits you can expect with SOA, and how IBM can help take your business there.

Gartner Magic Quadrant for Application Delivery Controllers
Gartner summarizes its view on Application Delivery Controllers, evaluates strengths and weaknesses of solutions, and provides Magic Quadrant reporting for a quick comparison across all vendors. Learn from Gartner how you can benefit from an all-in-one device like Citrix NetScaler that delivers the highest levels of availability, performance and security.

Knowledge is Power
What you don't know can hurt you, and is likely costing you money and increasing your security risks during an era of scarce resources. This white paper proposes six key strategies that enterprise security managers can use to improve their network defense posture.

Rationalizing the Multi-Tool Environment
The rationalized multi-tool approach is flexible, scalable and cost effective. It provides the necessary input to the IT service management business processes. It preserves prior investments in monitoring tools, empowers technologists to select the best tools with which to do their jobs, and enhances effective response to incidents.

More Free IT White Papers!