Service tries to connect to SQL DB before SQL is ready to accept client connections
Posted on 2007-08-02
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...