• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

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

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...
0
zephyr_hex (Megan)
Asked:
zephyr_hex (Megan)
  • 3
1 Solution
 
QlemoC++ DeveloperCommented:
Add your sqlserver service to your application service dependancies. This might delay the start till your sql instance starts.
0
 
zephyr_hex (Megan)DeveloperAuthor Commented:
how do i add the dependency?  i see the list of dependencies... but no option to Add
0
 
zephyr_hex (Megan)DeveloperAuthor Commented:
ok, i found how to add a dependency..
http://support.microsoft.com/kb/193888
0
 
zephyr_hex (Megan)DeveloperAuthor Commented:
perfect.  that worked
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now