SQL server 2014 for Calypso

Question

I am trying to install SQL server as part of a program package ZEISS Calypso. I get though the install but it fails to start the service. I can not start it manually. I have made sure the TLS 1.2 and the .NET 3.5 are enabled. This is on Windows 10 Enterprise verrsion 22H2.

Answer 1

If you are unable to start the SQL Server service after installation, it could be due to several reasons. Here are some troubleshooting steps you can take:

1. Check the Event Logs: Look for specific error messages in the Windows Application and System logs that could provide insight into why the service is failing to start.
2. Service Account Permissions: Ensure that the service account configured for SQL Server has the necessary permissions. You can check the effective access of the SQL Server service account by navigating to the SQL Server installation folder, right-clicking on it, and checking the Security settings.
3. Protocols: Verify that the required network protocols are enabled. If all network protocols are disabled, SQL Server will not start. You can enable protocols using SQL Server Configuration Manager.
4. TLS Settings: Since you mentioned that TLS 1.2 is enabled, ensure that TLS 1.0 or TLS 1.1 is not disabled, as some older versions of SQL Server may require them during installation or startup.
5. Reinstall SQL Server: If the above steps do not resolve the issue, consider reinstalling SQL Server, ensuring that all prerequisites are met and that you are using a version that supports TLS 1.2.

If you continue to experience issues, you may want to consult the SQL Server documentation for more detailed troubleshooting steps.

---

References:

• SQL Server startup errors on a standalone server
• Access is denied error and SQL Server doesn't start
• SQL Server can't start if all the protocols are disabled