How to install SQL 2008 Manually for SalesPRO

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 installed first. 

Also note that all Windows Updates must be installed on this computer prior to installation.

Instructions

  1. Download Microsoft SQL Server  2008-R2 SP2 Express Edition here: https://www.microsoft.com/en-us/download/details.aspx?id=30438
  2. Assuming that your computer is 64-bit, select the file called SQLEXPR_x64_ENU.exe
  3.  Click Next
  4. Save the file and when completed, click Run 
  5. Select New install
  6. You will also need to accept terms and conditions on the next window
  7. Continue to click Next until you get to the Instance Configuration screen 
  8. Select Named Instance and enter SWCS5
  9. Click Next
  10. Choose Mixed Mode and enter the password swcs#2016 in both boxes
  11. Click Next when prompted until installation is completed

Applies to:

  1. Solatech SalesPRO

    • Related Articles

    • Manually Installing SQL Server for SalesPro

      Summary: SQL server must be installed manually until the Installation Assistant gets fixed. The directions to do this are as follows: Must first check to make sure what version of SQL server customer is running. For new installations, no SQL server ...

    • 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 Express 2005 fails to Install MSXML 6

      Summary Cause MSXML 6 is in protected mode when installed from Windows Service Pack 3 for XP. When the Solatech 4.2 Installation Assistant tries to install a different version of MSXML 6 the installation of the prerequisites fails. Resolution 1 ...

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