query timed out expired

Question

query timed out expired

ramyours2003

SSChampion

Points: 12268
More actions
March 12, 2014 at 10:13 am

#305072

while connceting server i am getting query timed out expired , how to slove this

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 1

Check the "Remote Query Timeout" setting under your Connections tab for the SQL Server, you can set a default timeout from there, or set it to 0 (no timeout)

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

ManicStar SSCoach Points: 17992 More actions · Answer 2

Your connection parameters may be bad as well. Double check the servername, etc.

If the servername seems correct, try pinging it, connecting with the IP directly etc.

ramyours2003 SSChampion Points: 12268 More actions · Answer 3

default is 600 secs if i change to 0 is it will impact the other applications?

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 4

Yes, this is a server-level setting.

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 5

Also check if you are having blocking\ resource contention happening on the server ? Did you check the error log around timeout ?

--

SQLBuddy