Reply to thread

Message

<blockquote data-quote="sjevtic" data-source="post: 860415" data-attributes="member: 118214">Very true. Did anything happen during the reboot that could have caused a fallback to an alternate control set and subsequent loss of the dependency?&nbsp;I added a dependency like this:&nbsp;[code]sc config TvService depend= SQLBrowser/Netman/MSSQLSERVER[/code]&nbsp;&nbsp;Note that SQLBrowser and Netman were TVService's pre-existing dependencies. Unfortunately this didn't produced the desired result, and instead led to the dreaded &quot;The database backend (provider SQLServer) could not be reached&quot; error. While the system event log indicates that SQL Server was indeed launched before TVServer, I suspect that what's going on here is a race condition in the sense that SQL Server reports that it is &quot;started&quot; to the Service Control Manager (the only prerequisite introduced by the dependency) before it is ready to accept client requests for the MPTvDb database.&nbsp;Back to the drawing board--maybe it's time for a script. Sigh.&nbsp;Sasha</blockquote>

[QUOTE="sjevtic, post: 860415, member: 118214"] Very true. Did anything happen during the reboot that could have caused a fallback to an alternate control set and subsequent loss of the dependency? I added a dependency like this: [code]sc config TvService depend= SQLBrowser/Netman/MSSQLSERVER[/code] Note that SQLBrowser and Netman were TVService's pre-existing dependencies. Unfortunately this didn't produced the desired result, and instead led to the dreaded "The database backend (provider SQLServer) could not be reached" error. While the system event log indicates that SQL Server was indeed launched before TVServer, I suspect that what's going on here is a race condition in the sense that SQL Server reports that it is "started" to the Service Control Manager (the only prerequisite introduced by the dependency) before it is ready to accept client requests for the MPTvDb database. Back to the drawing board--maybe it's time for a script. Sigh. Sasha [/QUOTE]

Verification