The Full Text Index Service and the Full Text Index Search Service both require the MSSQLServer service to be running when the services are started. If Archive Manager and SQL are on the same server, the Full Text Index Service and Full Text Index Search Service will not start automatically after a restart due to the MSSQLServer service not running at the time the Archive Manager services are started. This is because the MSSQLServer service takes significantly longer to launch than the Archive Manager services.
Event Viewer will display errors similar to:
Login failed for user 'xxxxxx'.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&isInTransaction)at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConn ection(SqlConnectionString options, Boolean& isInTransaction)at System.Data.SqlClient.SqlConnection.Open()
To resolve this issue you must make the Full Text Index Service and the Full Text Search Service dependent on the MSSQLServer service. This will allow the Archive Manager services to launch once the MSSQLServer service has fully started. Please note that the commands below should only be ran if you have Archive Manager and SQL installed on the same server.
sc config "Archive Full Text Index Service" depend= "MSSQLServer"
sc config "Archive Manager Full Text Search Service" depend= "MSSQLServer"
Alternately, please review the Microsoft Solution below for instructions on manually creating the dependencies though regedit:
http://support.microsoft.com/default.aspx?scid=kb;en-us;193888
