SQL Server not Accessible Error Message

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 renamed your computer. 

More Information

In order for applications to access a Solatech Window Covering Software company database, the database server must be running. and properly configured. The server is run as a Windows service that normally is configured to start automatically when Windows starts.

Solution 1: Check to See if SQL Server is running and start the service manually on Windows 7, 8 or 10 (if required)

  1. Type the word services in the search bar in the lower left hand corner of your computer screen OR go to Control Panel>Administrative Tools>Services
  2. Double click on Services (Desktop App) when it appears in the search results
  3. Locate and select the service called SQL Server (SOLATECHDB)
  4. Click on Start
  5. Close the Services window.


Solution 2: If SQL Server is running and a Restart is necessary on Windows 7, 8 or 10 (if required)

  1. If you have followed the steps in Solution 1 and have the following results, simply click Restart. 
  2. Close the Services window.


Solution 3: Modify the psd file if the computer has been renamed

  1. Navigate to the Solatech Data folder (typically found at C:\\Solatech Data\WCS4)
  2. Within the WCS4 folder, open the Companies folder
  3. Within the Companies folder, you will see various files.  Open the file that has the extension ".psd" using notepad
  4. The computer name will be found between the word <Host> and \SOLATECHDB as highlighted below
  5. Change this text to the new computer name, and then save and close the file.

APPLIES TO
  • SWCS 4.2


    • Related Articles

    • 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 ...
    • 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 ...
    • Error 9003 when attaching a database

      Problem When attempting to attach a company database to SQL Server using SQL Server Management Studio you receive error 9003 with a message similar to this: The log scan number %S_LSN passed to log scan in database '%.*ls' is not valid. This error ...
    • 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 ...
    • Error: A new company could not be created because the server... could not be verified

      Symptoms When a new company is created an error message similarly to the following is displayed and the new company is cannot be used: A new company could not be created because the server 'xxx' could not be verified. Cause This problem can occur if ...