Cannot connect to Solatech database server

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 happen if:

  • The user 'sa' on the server was deleted or renamed.
  • The password for the 'sa' user was removed or changed.

Use Microsoft SQL Server Management Studio Express to log into the server and fix the 'sa' user. Contact Solatech for information on how to repair the 'sa' user.

The Solatech instance of SQL Server (SOLATECHDB) should never be changed or used by any other application other than the Solatech Window Covering Software.

REFERENCES

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

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

APPLIES TO

  • Solatech Window Covering Software 4.0
  • Solatech Window Covering Software 4.1
  • 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 ...

    • Database service not found

      Summary The instance of SQL Server for Solatech was not found on this computer. More Information When the Solatech Window Covering Software is installed it installs an instance of Microsoft SQL Server Express 2005. This instance of SQL Server is what ...

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