Service tries to connect to SQL DB before SQL is ready to accept client connections

Posted on 2007-08-02
Last Modified: 2010-03-19
SQL Server 2005

there is a service for an application that runs at startup.  i set up a DB in SQL for this application...
the service is failing to start when i boot up.  however, it starts fine when i manually start it after boot up is complete.

looking at the SQL logs, it has several instances of messages stating the server is not ready to accept logins..

is it possible that the service is requesting access to its DB before SQL is ready?  if so, how do i correct the problem so that the service does not have to be manually started?

i can also see a similar sequence of events in Event Viewer.  i see connection failures from the services followed by errors from SQL saying its not ready to accept client connections...
Question by:zephyr_hex
    LVL 67

    Accepted Solution

    Add your sqlserver service to your application service dependancies. This might delay the start till your sql instance starts.
    LVL 42

    Author Comment

    how do i add the dependency?  i see the list of dependencies... but no option to Add
    LVL 42

    Author Comment

    ok, i found how to add a dependency..
    LVL 42

    Author Comment

    perfect.  that worked

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now