How to stop and restart SQL Server 2005 Express

How to stop and restart SQL Server 2005 Express

Summary

This article explains how to stop and restart SQL Server Express 2005 and explains why you may want to do it on a regular basis.

More Information

SQL Server Express runs as a Windows Service, which means it's started automatically when the computer is turned on and continues to run until the computer is turned off. One of the knows design issues with SQL Server Express is that it does not free the memory it uses. Since it never shuts down and never releases memory it could potentially cause problems with other applications running on the same computer. To resolve this issue without restarting the computer you must stop and restart the SQL Server Express service.

Note: Stopping any SQL Server related service will disconnect any users from the SWCS company database. Make sure all users have closed any instance of SWCS before you continue.

To verify stop and restart the required services:

  1. Click Start, All Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Surface Are Configuration.
  2. At the bottom of the screen, click Surface Area Configuration for Services and Connections.
  3. From the list on the left, expand the instance of SQL Server that you are trying to connect to. For normal SWCS installations this will be 'SOLATECHDB'.
  4. Expand Database Engine.
  5. Click Service.
  6. Click the Stop button. Wait for the status to change to Stopped.
  7. Click the Start button. Wait for the status to change to Running.
  8. From the list on the left, expand SQL Server Browser.
  9. Click Service.
  10. Click the Stop button. Wait for the status to change to Stopped.
  11. Click the Start button. Wait for the status to change to Running.
  12. Click OK.
  13. Close SQL Server 2005 Surface Area Configuration.

APPLIES TO

  • Solatech Window Covering Software 4.2

    • Related Articles

    • SQL Server Express 2005 fails to Install MSXML 6

      Summary Cause MSXML 6 is in protected mode when installed from Windows Service Pack 3 for XP. When the Solatech 4.2 Installation Assistant tries to install a different version of MSXML 6 the installation of the prerequisites fails. Resolution 1 ...
    • SQL Server not Accessible Error Message

      Summary You may receive the message that SQL Server is not accessible when trying to open your Solatech company.  Although there are various reasons for this error message, the two most common are that either SQL Server isn't running or that you have ...
    • Manually Installing the 2008 SQL Server

      Summary: At times, the 5.0 Installation assistant does not install the newer 2008 SQL server. If this happens, it must be manually installed. The directions to do this are as follows: Must first check to make sure what version of SQL server customer ...
    • Which Edition of Microsoft SQL Server Should we Use

      Summary This article will explain the differences between Microsoft SQL Server Express Editions vs. the other editions of SQL Server (such Standard, Developer, Enterprise, etc.), as they relate to the Solatech Window Covering Software. More ...
    • How to disable AutoClose in SQL Server 2005

      Summary This article explains how to disable the AutoClose database property for SQL Server 2005 databases. More Information There is a feature in the database engine that SWCS uses, Microsoft SQL Server Express Edition, that causes it to ...