Saturday, 9 July 2016

SQL Server Express 2008 error -2146893007, service won't start for Microsoft Office Accounting 2009

Just discovered the old accounts package, Microsoft Office Accounting 2009 won't load. It reports ExecuteRestricted.exe crashed, then tries to load MS Office Accounts again and prompts to start a new company. After a bit of digging through Event Viewer for useful error codes we found that trying to start the SQL Server (SQLEXPRESS) service failed, reporting error -2146893007.

Event Viewer indicates that this is an SSL related error. So, we realised that TLS 1.0 had recently been disabled on this PC in line with PCI recommendations. We use the excellent IISCrypto utility to achieve this quickly and simply. Reinstating TLS 1.0 (no reboot required) allowed the SQLEXPRESS service to start up again.

No comments:

Trust 1&1 Internet for your domain name registration, from only £1.99/year!. Check now!