Solved

I have a server timout when trying to conect to a sql server remotely from the internet via app

Posted on 2008-06-09
7
169 Views
Last Modified: 2010-03-19
I have an application that works locally but when I access the same url to access the database it times out.  What settings can I use or check to increase some timeouts.  I have had this problem before.
0
Comment
Question by:mphillip85
  • 3
  • 3
7 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
Comment Utility
you need to check the query and tune it up accordingly
0
 

Author Comment

by:mphillip85
Comment Utility
I am only able to modify the SQL server. not the code.  please bemore specific.  thanks.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
is this on the connection or on running the query that the application times out?
please clarify
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:mphillip85
Comment Utility
connection from what I can tell.

thanks
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
>connection from what I can tell.
you will need to be sure... adding error handler to give a clear message when exactly the error occurs...

now, if it's really the connection, did you check all the connection requirements?
* firewalls not blocking
* sql server allowing remote connection
* the login used is allowed
* if it's a non-windows login, are non-windows logins allowed in general
...
0
 

Author Comment

by:mphillip85
Comment Utility
all the above are ok.  

remote timeout stttings? maybe?
or just a latency issue?

thanks
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
the default connection timeout is 30 seconds...
which cannot be controlled "remotely" from the server, it's the application/connection string defining this.

now, 30 seconds is a long time, so instead of trying to solve the symptoms, get rid of the causes.
what is the connection string, btw?
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now