Web Wiz Forums - Timeout Expired Error in 7.5

Print Page | Close Window

Timeout Expired Error in 7.5

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=6996
Printed Date: 03 April 2026 at 11:14pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Timeout Expired Error in 7.5

Posted By: wistex
Subject: Timeout Expired Error in 7.5
Date Posted: 04 November 2003 at 12:31pm

Hello:

We just upgraded to 7.5 and moved to a new server with a SQL 2000 database. We are now getting the following error:

Internet Explorer wrote:

Microsoft OLE DB Provider for SQL Server error '80004005'

Timeout expired

/forums/common.asp, line 249

This error will appear intermitently as you use the website and appears to occur at the point where it is trying to connect to the database.

The SQL Server and the Web Server are on different servers. Here is our configuration:

Web Server: Windows 2003 IIS 6.0 (We have the whole server to ourselves.)
SQL Server: SQL 2000
DNS: Running on our web server. The web server itself uses the DNS server of our web hosting provider. Our DNS also forwards any requests it can't answer to our web host's DNS server.
Forum Version: 7.5 unmodified, clean install, data from 7.01 imported. Data in tables from old SQL 7 WWF 7.01 were copied into the new SQL 2000 WWF 7.5 tables. The set-up script that came with WWF 7.5 was used to create the tables in SQL 2000.
OS & Web Browser on local machine: Windows 98 & Internet Explorer 6.0 Service Pack 1

Pinging from the web server to the SQL server is less than 1 ms and doesn't appear to timeout even after pinging constantly for 30 minutes. So it doesn't appear to be a connectivity problem on a network level.

Any database page also loads really slow.

Any ideas?

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Replies:

Posted By: WebWiz-Bruce
Date Posted: 04 November 2003 at 1:19pm

The error suggests a database problem and on that line suggests some sort of problem connecting to the database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: wistex
Date Posted: 04 November 2003 at 1:49pm

I changed from SQL 7.0 to SQL 2000. Is there anything that I need to change along those lines?

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: WebWiz-Bruce
Date Posted: 04 November 2003 at 2:43pm

Have you tried running quiries on the SQL server to se if it is that, which is running slow?

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: wistex
Date Posted: 04 November 2003 at 2:54pm

Is that something that could be done from Enterprise Manager? I have no access to the SQL Server other than that. The SQL server is used by a lot of web sites, not just ours. We have our own dedicated web server, though.

I've already reported the problem to our web host who runs the shared SQL server. They are working on it.

I just want to make sure that it isn't something on our web server that is causing the problem. If the problem is with their SQL server, then, in reality, they are much better equiped to deal with it that I am.

If I had them run around for a problem on my server, I might wind up with a bill.

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: wistex
Date Posted: 04 November 2003 at 10:09pm

Just to give an update. The problem is an overloaded SQL server. They are working to offload some of the sites to a new server as we speak.

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums