<div>
how do i add the dependency? &nbsp;i see the list of dependencies... but no option to Add
</div>


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

<div>
ok, i found how to add a dependency..<br />
<a href="http://support.microsoft.com/kb/193888" rel="ugc nofollow">http://support.microsoft.com/kb/193888</a>
</div>


ok, i found how to add a dependency..
http://support.microsoft.com/kb/193888 [http://support.microsoft.com/kb/193888]

<div>
<div class="content wysiwyg-content">
SQL Server 2005<br />
<br />
there is a service for an application that runs at startup. &nbsp;i set up a DB in SQL for this application...<br />
the service is failing to start when i boot up. &nbsp;however, it starts fine when i manually start it after boot up is complete.<br />
<br />
looking at the SQL logs, it has several instances of messages stating the server is not ready to accept logins..<br />
<br />
is it possible that the service is requesting access to its DB before SQL is ready? &nbsp;if so, how do i correct the problem so that the service does not have to be manually started?<br />
<br />
i can also see a similar sequence of events in Event Viewer. &nbsp;i see connection failures from the services followed by errors from SQL saying its not ready to accept client connections...
</div>
</div>


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...

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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.