I am getting SQl timeout from SQL server 2005. My sql statement is taking more than 15sec.
I used database engine tuning advisor. But it doesnt give any recommendations. I changed remote query timeout to 6000 in Connection page in MS SQL Server Management Studio.
I added timeout to connnection string too.
Connection string="data source=xxxx;database=yyyy;user=aaa;password=bbb;timeout=6000"
But I am still getting timeout error.
Do you have any recommendation. Why does not sql server look timeout?