Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Timeout Expired Error in 7.5
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Timeout Expired Error in 7.5

 Post Reply Post Reply
Author
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post Topic: Timeout Expired Error in 7.5
    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:

Originally posted by Internet Explorer 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?

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.