Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brkonthru
Starting Member
31 Posts |
 Posted - 2001-05-21 : 18:32:43
|
| Hi there,This problem is really driving me crazy--> I had sql7 and my webserver(iis4) on the same machine and I had to separate them to two different machines because of capacity issues.I moved my web server to IIs5/w2k AS and kept the SQL DB on the same machine. At first i was able to connect just fine, but after almost of having the server up for a day it seems like IIS can no longer find/talk to the DB server. I start getting the usual script has timed out error from my ASP pagesThe interesting thing is it does not happen on all tables , just heavier ones. It also does not happen all the time meaning that after I initially experience the problem some pages go fine. The only pattern i see is that after of having both server up for 24 hours the ASP script timeout start occurring and only after restarting both server dissappear and of course only re appearing again after aprox. 24 hours a day. I checked my SQL server and my web server both seem to have normal memory/cpu usage at the time when I experience the connectivity problemhere is my connection string:"Provider=SQLOLEDB; Data Source=xx.xx.xx.xx,1433; Initial Catalog=jeerandbsql; network=DBMSSOCN;User ID=user; Password=pass;"What can be causing these script on my ASP pages that are due to a slow response from the DB pages? Thank you and I would highly appreciate any input, |
|
|
|
|
|
problem connection to sql server