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

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.
mphillip85Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
you need to check the query and tune it up accordingly
0
 
mphillip85Author Commented:
I am only able to modify the SQL server. not the code.  please bemore specific.  thanks.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is this on the connection or on running the query that the application times out?
please clarify
0
 
mphillip85Author Commented:
connection from what I can tell.

thanks
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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
 
mphillip85Author Commented:
all the above are ok.  

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

thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.