I need help I'm running an SQL query that sometimes works in about 30-45 seconds but usually times out in about 30 seconds.

Here's my connection string, I set the timeout to 180 (3 minutes), and the server is set to 600, but the web page fails and an exception is thrown 'SQL server timeout', within about 30 seconds.

Is there another setting thats not allowing it to try for the full 180 seconds?

"Server=x.x.x.x;Database=mydb;Uid=MyUser;Pwd=MyPass;Connect Timeout=180;" />