I have a slow database and my server keeps timing out on the SQL Connections after 30 seconds. I want to increase this time to 90 seconds.
I have increased the connect timeout to 90 seconds in the web config
<add key="ConnectionString.Databasel" value="Initial Catalog=db;Data Source=localhost;User ID=test;password=test;Connect Timeout=90" />
and modified to the machin.config to be 90 seconds
after each setting Ive reset the server but still get the timeout after 30 seconds. any idea how to increase this.