sqlserver connection timeout is NOT query timeout
I hit a problem of query timeout. This is a freaking old problem but just that we need to understand differences between connect timeout and query time out. If you don't you find yourself setting a connection string and getting exception over and over again.
The main different is message your get as shown here :-
Connection time out and its exception message.
To solve this you can change the connection string which is pretty straight forward;
Query timeout and its exception message