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

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

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

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