Microsoft IIS
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsSystem AdministrationMicrosoft IIS

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old December 2nd, 2004, 03:55 PM
tpmac tpmac is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Posts: 14 tpmac User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Angry 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.

Reply With Quote
  #2  
Old December 2nd, 2004, 06:47 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
 
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 23 h 29 m 58 sec
Reputation Power: 181
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

Reply With Quote
  #3  
Old December 6th, 2004, 09:01 AM
tpmac tpmac is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Posts: 14 tpmac User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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.

Reply With Quote
  #4  
Old December 6th, 2004, 02:52 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
 
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 23 h 29 m 58 sec
Reputation Power: 181
I guess check the server's event logs for any clues? Maybe someone that knows clusters can jump in.

Reply With Quote
  #5  
Old December 10th, 2004, 04:22 PM
tpmac tpmac is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Posts: 14 tpmac User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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.

Reply With Quote
  #6  
Old December 10th, 2004, 09:01 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
 
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 23 h 29 m 58 sec
Reputation Power: 181
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

Reply With Quote
Reply

Viewing: ASP Free ForumsSystem AdministrationMicrosoft IIS > ASP can't connect to DB on new iis 6.0 install


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
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


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT