SQL Server Connectivity Issues

I am having problems with my Windows re-seller hosting and SQL Server. My host company (Heart Internet) updgraded their server the other day and since then I've had numerous problems, most which were easily fixable but I now have a connection issue. I've had about 200 error 500 messages within 48 hours all to do with connectivity.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
[Microsoft][ODBC SQL Server Driver]Login timeout expired
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Script timed out
[Microsoft][ODBC SQL Server Driver]Query timeout expired

My web host has basically thrown the problem back at me with an error message from their logs:

"A worker process with process id of '9932' serving application pool 'mydoman.com' has requested a recycle because it reached its private bytes memory limit."

and telling me to contact the script developer.

I found something here:
http://www.linkedin.com/answers/technology/web-development/TCH_WDD/671814-64826154

Can someone please explain in simple terms what's going on and what my options are to resolve it?

Thanks.
benners70Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

paritoshjaniCommented:
Hi,

Looking to this error it seems that your web & database server are isolated. During the error, you can telnet your SQL server (telnet sqlserver 1433) and if there is any error returned it is certainly that there is SQL Server is not responding. You can share this error with your ISP.

In addition, you can open the database through sql management studio and see if it accessible.

NOTE: This has nothing to do with your applicaton pool recycling.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
benners70Author Commented:
I've tried telnet and get the following message. Is this the problem or is telnet not available?
C:\Documents and Settings\Paul Benbow>telnet 79.170.140.192 1433
Connecting To 79.170.140.192...Could not open connection to the host, on port 14
33: Connect failed
paritoshjaniCommented:
benners70,

the command is absolutely right and it indicates 3 possibilities
1) SQL server is not reponding
2) SQL server is setup on different port (You can check with your hosting provider)
3) Remote connections to SQL are not allowed

If the first point is the case, your sql application would not be functioning. Are you able to connect to sql through management studio ?
benners70Author Commented:
I will check correct port setting. I have been told settings for app pool have been changed on the new server due to instability with the previous server. I have requested details on the new settings. I need to establish if my scripts are a problem or the new server settings are insufficient and unreasonable. Will post again when I have the settings.
benners70Author Commented:
I've been given the following settings regarding app pool

AppPoolRecycleTime = 1740 mins
AppPoolRecycleRequests = 0 [unlimited number of requests]
AppPoolRecycleSchedule = not listed
AppPoolRecycleMemory = 0 [no limit]
AppPoolRecycleIsapiUnhealthy = not listed
AppPoolRecycleOnDemand = not listed
AppPoolRecycleConfigChange = not listed
AppPoolRecyclePrivateMemory = 128mb

Can someone please advise me if I these settings are sufficient and reasonable?

If they are ok, how can I adjust my ASP code to work with these settings? I don't know if my scipts perform too many DB connections, although it's not been a problem before.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.