How to install SQL Server Manually for Fabrication Software

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 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 SOLATECHDB
  9. Click Next
  10. Choose Mixed Mode and enter the password swcs#2009 in both boxes
  11. Click Next when prompted until installation is completed

Install SQL 2005 Native client

  1.  https://www.solatech.com/downloads/sql/sqlncli_2005_x64.msi

Applies to:

  1. Solatech Fabrication software

    • Related Articles

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

    • Understanding How Pricing Works In Solatech Fabrication Software

      Summary This article explains how Solatech Software calculates the pricing for line items in Order Entry. More Information We will begin in order entry, and review how pricing is calculated in various scenarios. Edit Item Price Window To access the ...

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

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