Navigation: Installation > Scan2x Windows (on-premise) >

SQL Express & SSMS Installation

 

 

 

 

SQL Express & SSMS Installation

 

During the Scan2x installation, when the button is clicked (highlighted in red in the image below), your PC will automatically start to download SQL Express.

 

 

Double click on the SQL Express exe file and the following screen will appear.

Click Basic.

 

 

Review the licence agreement and press Accept to continue.

 

 

Click Install.

 

 

 

Once SQL Express is installed, you can also click Install SSMS.

 

 

You will be redirected to the Microsoft site where you can download SSMS by hitting the link shown in the image below.

 

 

 

Double click on the SSMS exe file and the following screen will appear.

Click Install.

 

 

 

A restart will be required in order to complete the setup. Click Restart.

 

 

Note: Please make sure the below options are set accordingly in SSMS if you are going to authenticate in Scan2x via SQL - If you will be using Windows Authentication, please continue following the Scan2x installation steps.
First, if needed, change the password of the login user 'sa' to one that you know by:
- Go into SSMS
- Logging in with the default windows authentication
- Open the security file
- Open the logins file
- Right-click on the user 'sa'
- Click properties
- In the General tab, one can change the password
- Make sure that in the Status tab for the same user, that the login option is enabled
- Click OK

In order to fix the SQL login issue, one must then:
- Go into SSMS
- Login with the default database with windows authentication
- Once logged in, right-click on the instance (first item in the list)
- Select properties
- Go in to the security tab
- Select 'SQL Server and Windows Authentication Mode'
- Click OK

Once applied, disconnect from the database and try and login with the default user 'sa' with the SQL authentication.
 

Continue following the Scan2x installation steps.

 

 

 

 

Copyright © 2023 Avantech Software