Navigation: Installation > Scan2x Web Access Server and/or Scan2x Hybrid Installation >

SQL Express & SSMS Installation

 

 

 

 

SQL Express & SSMS Installation

 

Please find a simple step by step guide on the installation of SQL Express and SSMS (SQL Server Management Studio).
For more information about SQL Express, please click the following link: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
For more information about SSMS, please click the following link: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

 

Login to Scan2x and click on the Admin Panel button from the left-hand side of the home screen.

 

From the System tab, click on the Connection Settings button.

 

The screen will open on the MS SQL tab. 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 in order to authenticate in Scan2x via SQL

First, if needed, change the password of the login user 'sa' to one that you know, by:
- Going into SSMS


- Logging in with the default windows authentication


- Opening the security file
- Opening 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

 

Note: 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.
 

Load Scan2x and login, go to Admin Panel, click on the Web Installer Setup tab, and click Launch new installation Wizard button.
Then one clicks either the Standard or Custom download.

 

 

 

 

Copyright © 2024 Avantech Software