• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

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.
0
mphillip85
Asked:
mphillip85
  • 3
  • 3
1 Solution
 
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is this on the connection or on running the query that the application times out?
please clarify
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
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
 
Guy Hengel [angelIII / a3]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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now