SQL server 2005 timeout problem

Posted on 2008-11-14
Last Modified: 2012-05-05
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?
Question by:aesatlanta
    LVL 7

    Expert Comment

    In SQL Server Management Studio, go to the menu, select tools, and options.
    In the options window, click query execution.
    What does you Execution time-out field say?
    It should be 0.
    LVL 21

    Accepted Solution

    I think that connection string timeout is a timeout for the connection attempt.  You need to set the query timeout in the application you are using (or do something to reduce the execution time).  For instance, in .Net it would be SqlCommand.CommandTimeout.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now