Link to home
Start Free TrialLog in
Avatar of msdba
msdba

asked on

connection timeout when connecting to a database

Hi All,
I'm trying to connect to a database and I'm getting error saying connection timeout.
what should I do?
pls help me.
Thanks!

ASKER CERTIFIED SOLUTION
Avatar of cfEngineers
cfEngineers

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of msdba
msdba

ASKER

Hi, thanks for the comments.
how to increase the timeout property?
yes, I'm able to connect to database before.
I'm new to sql and don't know more details on how to trouble shoot.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of msdba

ASKER

Hi, I'm getting this time out issue when I'm testing a select query.
I verified the options you suggested and every thing looks ok there as you suggested.

do you think deadlock or blocking might be causing this issue?

how to resolve or check for blocking problems?
pls advise.
SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of msdba

ASKER

Thanks 2 All!