How to disable AutoClose in SQL Server 2005

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 automatically close the connection to the database when it's no longer being used. This has the effect of slowing down the software significantly as a new connection must be opened each time the database is accessed.

Normally when a company is opened the software checks to see if this property is turned on. If it is then it's automatically turned off. If you need to check this setting, or turn it on/off manually you must use the Microsoft SQL Server Management Studio Express.

To see if you have the Management Studio Express software installed, click Start, All Programs, Microsoft SQL Server 2005 and then look for a menu called "SQL Server Management Studio Express". If you don't see this then you probably don't have the studio installed (it's not installed by default).

To install Microsoft SQL Server Management Studio Express

  1. Download the setup program from http://www.solatechonline.com/software/SQLServer2005_SSMSEE.msi. When prompted to Run or Save, choose Save. Save the file to your Desktop.
  2. Once the download has finished, close all running applications.
  3. Locate the file SQLServer2005_SSMSEE on your desktop and double-click on it.
  4. Follow the instructions of the setup program. Use the default for all options. It should take just a few minutes to install.
  5. Once setup has finished you can delete the file SQLServer2005_SSMSEE from your desktop.

To disable AutoClose

  1. Click Start, All Programs, Microsoft SQL Server 2005, SQL Server Management Studio Express.
  2. When prompted to login you will need to select the SQL server that has the SWCS database. Expand the drop down for 'Server name' and select the one with "SOLATECHDB" at the end.
  3. Select "Windows Authentication".
  4. Click Connect.
  5. From the list of items in the Summary pane, double-click on Databases.
  6. Find the database for your company and right-click on it.
  7. From the menu select Properties.
  8. Select the Options page.
  9. From the list of properties on the right, look for one called Auto Close.
  10. Change it's value to False.
  11. Click OK.
  12. Close the Management Studio.

REFERENCES

For more information, refer to the following knowledge base articles:

  • How to prevent the database AutoClose property from being reset

APPLIES TO

  • Solatech Window Covering Software 4.2

    • Related Articles

    • How to prevent the database AutoClose property from being reset

      Summary This article explains how to prevent the Solatech Window Covering Software (SWCS) from disabling the AutoClose database property. More Information There is a feature in the database engine that SWCS uses, Microsoft SQL Server Express Edition, ...

    • SWCS 4.x can't access a SQL Server 2005 database

      Symptoms When you attempt to open a company file located on a server using SQL Server 2005 you receive the following error message: The company '...' is not a valid company or you don't have permission to access it. Check with your system ...

    • 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 ...

    • How to resolve the SQL Server Not Accesible Error Message

      Summary You may receive the message that SQL Server is not accessible when trying to open your SalesPRO 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 ...

    • 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 ...