| Author |
 Topic  |
|
bulldale
Starting Member
14 Posts |
 Posted - 14 July 2005 : 13:17:26
|
Thanks in advance for any comments.
We upgraded to Windows 2003 server from 2000 with IIS5 on our development server. The server had a few different sites with probably 5 snitz forums on the different sites. They all connect to different SQL2000 databases on a separate server.
The live server also connects to the same databases on the SQL server.
The live forums can access the SQL server just fine. Since the upgrade to 2003, none of the forums can be accessed from the development server, or any web browser.
This is the error I am receiving.
Active Server Pages error 'ASP 0113'
Script timed out
/forums/Default.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
I have already tried upgrading to SQL sp3a with no luck.
Any ideas as to what I can try? |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 14 July 2005 : 13:28:07
|
Try pinging the sql server i.p. address from the development server.
You may need to add a record in your hosts file and refer to the sql server that way e.g.
Search for a file called "hosts" on the dev machine.
Add a record like this (replace the i.p. with that of the sql server & domain with your own)
127.0.4.3 db.yourdomain.com
Save the hosts file
Restart the server
Change config.asp to connect to db.yourdomain.com on your dev server
Try browsing one of the forums. |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
-gary
Development Team Member
406 Posts |
Posted - 14 July 2005 : 14:58:18
|
Are you using TCP/IP, named pipes or both? Did you load the SQL client on the dev server or are you just using the default drivers? Are your client library options the same as your server? Is the server using the default 1433 port and the same on the client? Are you using the firewall in Win2K3 SP1?
Might not even be SQL problem. Have you watched the w3wp process to see if it might be maxing out the CPU for some reason? |
KawiForums.com
 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
-gary
Development Team Member
406 Posts |
Posted - 14 July 2005 : 18:30:06
|
| You should get a 404 if the asp Web Service Extension hasn't been enabled, but it's worth a look. |
KawiForums.com
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 July 2005 : 18:36:25
|
quote:
Originally posted by -gary
You should get a 404 if the asp Web Service Extension hasn't been enabled, but it's worth a look.
I got a timeout in a similar situation, thus my advice. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
bulldale
Starting Member
14 Posts |
Posted - 18 July 2005 : 16:10:25
|
Thank you for all of the feedback.
I can ping the server by FQDN, and all DNS info is correct.
We do have sites that use different.asp pages, and they haven't changed, they are still functional after the upgrade to Server2003. I am thinking that the issue involves SQL/2003 security.
We use both TCP/IP and named pipes. We aren't using the Win2k3 firewall on this server. We do use the default port 1433 that we used before the upgrade. Nothing has changed on the server that connected to SQL except for 2003.
The strange thing is that our live webserver accesses the exact same SQL database, except it's 2kServer and it doesnt have any issues connecting to it with IIS5.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
bulldale
Starting Member
14 Posts |
Posted - 19 July 2005 : 10:11:18
|
| SQL server & Windows authentication. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
bulldale
Starting Member
14 Posts |
Posted - 19 July 2005 : 11:18:54
|
For the SQL connector in Snitz? This account is using SQL authentication.
We are also using SQL authentication to access the same databases on the live server. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
bulldale
Starting Member
14 Posts |
Posted - 19 July 2005 : 16:03:14
|
We have MDAC 2.8 RTM installed, 2.8 SP1 can't be installed until 2003 SP1, and when I tried the upgrade to SP1, IIS started stopping and crashing within 2 minutes of startup.
I was hoping someone may have had a similar situation after 2003 upgrade. I've heard nothing but bad things about upgrading to SP1, and would like to wait until I find some other solution.
I did recently install a security update for MDAC, but no difference. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 July 2005 : 16:35:06
|
Well I don't know what else to suggest. Personally I don't have much experience with 2003, so I never had to deal with such a scenario.
Have you thought about installing the SQL Server Client tools in your 2003 box and then try to connect to the SQL Server? That could probably rule out connection issues from the 2003 box, or indeed confirm that the connections is the issue... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
bulldale
Starting Member
14 Posts |
Posted - 19 July 2005 : 17:20:51
|
Eventually I will need to try the upgrade to SP1 again, but am putting that one off for a while.
I'm almost positive now that it's not a snitz issue. I'll have to give the client tools a try.
Thanks for the help! |
|
|
|
Topic |
|
Topic Locked
