Manually Installing the 2008 SQL Server

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 is running.
    • Type SQL in search or scroll through programs.
    • If you find a program “Microsoft SQL Server 2005 – this won’t work.  Must have the 2008 version.
  • Go into an internet browser and search in google for:

    • Make sure you are going to a Microsoft site, not anything else.
  • Once that opens, click on Download.  This will take you to a screen that gives several options for downloading.  Which one you download will be determined by the PC it is being installed on. 
    • Go to Windows Explorer and right click on This PC, choose Properties.

    • Most computers will say 64-bit.  This example says 32-bit.  You must download the version that matches the computer.
    • The x86 file will be for a 32-bit, the x64 file will be for the 64-bit computer.
  • The following is the list of possible downloads, this example will use the x86 file because it is being installed on a 32-bit computer.

    • Select the file to download then click Next.
    • You will save the file first, then Run
  • Choose New Install.

  • When the window comes up to install, choose “I accept”, then “Install”.
  • At this point a restart may be required, if so you will have to let the customer restart then reconnect via TV.
  • Once reconnected, just restart the SQL server installation by double clicking on the downloaded file again (you will go back to the beginning.)
  • The next screen will have all boxes checked.

    • Click Next 
  • Click Next until  you get to the screen below.

    When you get to the screen below you will enter a new name in “Named Instance” – Use “SWCS5”


  • Click next until you get to the screen where you can pick “Mixed Mode”.

    • Choose Mixed Mode and click Next.
  • The next screen will ask for a password.  Enter swcs#2016 in both spaces.
  • Click Next until it starts going through the automatic installation process.
  • Once done installing, hopefully you get the following screen:

  • Now you can go back into SWCS5.0 and create a new company. You will have to enter information on the “Custom Properties” tab.
  • To find the Server Name you will have to go to C:\Solatech Data\WCS4\Companies.
  • Open the company file that is a PSD file in NotePad.

  • Copy the information between <Host> and <Host>.  This will be the Server Name.

  • Put in User Name “sa”
  • Put in Password: “swcs#2016”
  • This should allow the company to open. 
  • You are Done!!

    • Related Articles

    • How to install SQL Server Manually for Fabrication Software

      Summary This knowledge base article will outline the process of installing SQL Server on a computer which will be running Solatech Fabrication Software. Note that this installation is separate from the installation of Solatech Favrication software. ...
    • 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 install SQL 2008 Manually for SalesPRO

      Summary This knowledge base article will outline the process of installing SQL Server 2008 on a computer which will be running Solatech SalesPRO. Note that this installation is separate from the installation of SalesPRO software. SQL Must be ...
    • 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 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 ...