Performing advanced database tasks with SWCS 4.2
Summary
This article explains how a user can perform advanced database management tasks on a SWCS 4.2 company database.
The Solatech Window Covering Software version 4.2 uses Microsoft SQL Server 2005 as it's database engine. During installation, it installs Microsoft SQL Server 2005 Express Edition, however this edition does not include any user-interface tools to access the database and it's tables. To do this you must use Microsoft SQL Server Management Express.
The Microsoft SQL Server Management Express is a free utility that you can use to: Create, modify and delete databases, perform backups and access the raw data. This utility can be downloaded from Microsoft at:
http://www.microsoft.com/en-us/download/details.aspx?id=184
Note: Solatech does not recommend users use this utility to perform any tasks on a SWCS company database unless directed by Solatech support. Doing so could corrupt the database and prevent SWCS from being able to open or use the company.
APPLIES TO
- Solatech Window Covering Software 4.2
Related Articles
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 ...
How to rename a SWCS company database
Summary This article explains how to rename a SWCS 4.2 company database. More Information There are a few prerequisites that must be met before you rename the company database: The Microsoft SQL Server Management Studio Express tool must be installed ...
How to access the SWCS 4.2 company database using SQL Server Management Studio
This document assumes you are familiar with SQL Server and it's tools and have SQL Server Management Studio installed on your computer. In order to access the SWCS 4.2 company database you'll need to gather some information from SWCS such as the ...
How to delete a company in SWCS 4.2
Summary This article explains how to delete a company created in the Solatech Window Covering Software, version 4.2. Note: This article is for version 4.2 of the Solatech Window Covering Software. The process to delete a company is different in ...
Cannot connect to Solatech database server
Summary The instance of SQL Server for Solatech was found on this computer however a connection to the server could not be made. This problem can also occur if testing multiple connections to the company database fails. More Information This could ...