none
MSSQLSERVER The service did not start due to a logon failure.Event ID 9954

    Question

  • Every time I reboot a Server 2012 R2 running SQL 2012 ver 11.0.6020.0, MSSQLSERVER  service fails to start with the following error

    SQL Server failed to communicate with filter daemon launch service  (Windows error: The service did not start due to a logon failure.
    ). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.

    5 seconds later I get SQLISService110 service error event id 274

    Microsoft SSIS Service: 
    Registry setting specifying configuration file does not exist. 
    Attempting to load default config file.

    This is all happening during system start up. 

    First error indicates a logon failure for MSSQLSERVER service which is configured to run as a domain service account (svcsql@ourdomain.local) with log on as service right, additionaly svcsql@ourdomain.local is a member of Domain Admin group.

    Without touching the user name or the password I simply click Start on the service and it starts without any problems. 

    SQLISService110 also starts fine manualy, however fails the automatic start up after a reboot.

    Why would it fail during startup indicating a logon failure?

    Thanks

    Friday, December 2, 2016 3:13 PM

Answers

All replies