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 will be installed.
- Type SQL in search or scroll through programs.
- If you find a program “Microsoft SQL Server 2005 – this won’t work. We are now installing SQL 2019.
- Go into an internet browser and search in google for:
- Make sure you are going to a Microsoft site, not anything else.
- Make sure you are going to a Microsoft site, not anything else.
- Once that opens, click on Download.
- Once Downloaded, run the file.
- You will be asked if you want to install the Basic package, Custom, or one other choice.
- Choose Custom
- Choose New Install.
- When the window comes up to install, choose “I accept”, then “Next”.
You should get the following screen after it runs through the installation steps.
- Click Next to continue.
- In the following screen, only check the boxes you see checked below:
- Click Next to continue.
- In the following screen you need to name the SQL server instance. The default is SQLEXPRESS. You can leave it as that or change it to:
SWCS5 - Click Next to Continue
- On the next screen choose "Mixed Mode (SQL Server authentication and Windows authentication)"
- Then enter the password swcs in both spaces.
- Click Next
- At this point, it should run through all the required actions an finish successfully. In the event it tells you to restart, just click OK and allow it to run through the actions. Then restart and re-run the setup to make sure it is complete (To do this just double click on the SQL2019-SSEI-Expr.exe file again, located in your downloads folder.)
- This will run through all the steps again, but will be much quicker this time around.
- If you've had to run it through a second time, it should say the install was successful
- Now you can go back into SWCS5.0 and create a new company. You will have to enter information on the “Custom Properties” tab.
- Put in User Name sa
- Put in Password: swcs
- This should allow the company to open.
- You are Done!!
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 ...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. ...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 ...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 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 ...