Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Cannot start SQL Service after installing Apex Central 2019

    • Updated:
    • 17 May 2019
    • Product/Version:
    • Apex Central 2019.All
    • Apex Central All.All
    • Platform:
    • N/A N/A
Summary

After the installation of Apex Central, the following error message is seen when trying to start the SQL Service:

SQL Service Error

Windows could not start the SQL Server (INSTANCENAME) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 13.

Based on the ERROR.LOG located at C:\Program Files\Microsoft SQL Server\MSSQL13.OFFICESCAN\MSSQL\Log\Error.log, the following error lines can be seen:

2019-05-01 05:08:41.61 spid10s     Error: 17182, Severity: 16, State: 1. 
2019-05-01 05:08:41.61 spid10s TDSSNIClient initialization failed with error 0xd,
status code 0x4. Reason: All protocols are disabled. The data is invalid.
2019-05-01 05:08:41.61 spid10s Error: 17182, Severity: 16, State: 1.
2019-05-01 05:08:41.61 spid10s TDSSNIClient initialization failed with error 0xd,
status code 0x1. Reason: Initialization failed with an infrastructure error.
Check for previous errors. The data is invalid.

The SQL service fails because all protocols are disabled, and it was not able to establish connection to the SQL server.

Details
Public

To resolve this issue, the required protocols must be enabled. Do the following steps:

  1. Open SQL Server Configuration Manager.
  2. Expand SQL Server Network Configuration.
  3. Highlight Protocols for (INSTANCENAME).
  4. At the right side of the screen enable the following:
    • Named Pipes
    • Shared Memory
    • TCP/IP
  5. Reboot the server to allow the changes to take effect.
  6. Once rebooted check if the SQL service is already started.
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1122688
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.