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