How to Easily Fix This Error Message: Act SQL Server Not Running

by | Aug 1, 2023 | Act CRM Software Fundamentals

Introduction: Hello, ladies and gentlemen! If you’ve encountered the frustrating error message stating that “Microsoft SQL Server is not running,” preventing ACT from functioning correctly, fear not! In this quick tutorial, Tony Holowitz provides a simple solution to fix the issue and get ACT up and running smoothly again. Let’s dive into the steps to resolve this problem effortlessly.

The Error: ACT SQL Server Not Running At times, users may face an error message indicating that the “Microsoft SQL Server is not running.” This error can be a hindrance to using ACT, but Tony has an easy fix that will help you get back on track without spending time troubleshooting the underlying cause.

The Solution: Restarting the SQL Server Follow these straightforward steps to resolve the issue:

  1. Open the Run Box: Press the Windows logo key on your keyboard (usually located on the left-hand side at the bottom) and simultaneously press the letter “R” (as in Romeo). This will open the Run box.

  2. Enter “services.msc”: In the Run box, type “services.msc” (without the quotes) and click “OK.”

  3. Locate the SQL Server: In the Services window that opens, scroll down until you find “SQL Server” (Act7) in the list. Alternatively, you can click on any service and press the letter “S” to jump down to services starting with the letter “S.”

  4. Check Startup Type: Double-click on “SQL Server” to open its properties. Ensure that the “Startup type” is set to “Automatic.” This setting ensures that the SQL Server starts automatically with the computer.

  5. Restart the SQL Server: If the “Startup type” is not set to “Automatic,” change it to “Automatic” and click “Apply.” Then, click on “Start” to restart the SQL Server service.

Conclusion: By following these simple steps, you can quickly resolve the “Act SQL Server Not Running” error message. Restarting the SQL Server and ensuring it has the “Automatic” startup type will allow ACT to function smoothly again. Now you can go ahead and open your ACT database without any hindrance.

For more helpful tips and troubleshooting guidance, stay tuned to Tony Holowitz’s channel. Thank you for watching, and have a fantastic day!