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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks 2 All!
ASKER
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.