Journal
Knowledge base
How to install, upgrade or replace MSSQL Server for U-PROX IP

How to install, upgrade or replace MSSQL Server for U-PROX IP

Share and save

The entire MS SQL Server product line is supported — from 2008 R2 to the current versions SQL 2019/2022.

The simplest method for updating software components used in the U-Prox system (from the technical support perspective) is described below.

SQL 2014 — the last SQL Server edition available in both x32 and x64 versions.
The U-Prox installation package includes x32 versions of SQL 2014 and SQL 2008 R2.

SQL 2014 — installs on Windows 10, Server 2016, and newer OS versions.
SQL 2008 R2 — installs on Windows 7/8, Server 2008/2012, and older systems.

Starting with SQL 2016 and newer, all versions are released in x64 only.

If you have x32 SQL 2014 or SQL 2008 R2 installed, follow the instructions below.
If you are using x64 SQL 2014 or SQL 2008 R2, simply update.ть його до SQL 2016/2017/2019/2022.

The sequence of actions for updating MS SQL

If you simply launch the installation of SQL Server 2016/2019/2022 over an existing x32 SQL 2014 or SQL 2008 R2, only the server “features” will be updated — not the core “engine”.

To migrate to a newer SQL Server version (2016/2019/2022), follow these steps:

Uninstall the old x32 SQL 2014 or SQL 2008 R2 with the instance name SQLEXPRESS.
Restart the PC (this is usually required for successful installation of the new server).
Install SQL Server 2016/2019/2022 using the default instance name SQLEXPRESS.
Perform the necessary configuration — see the ReadMe files on the installation disc and Step 1 in the “FAQ”section on our website.
Attach the UProxIP databases to the new server (they will be automatically upgraded to the appropriate SQL Server version during the connection process).
Start the U-Prox software services:
- U-Prox IP Hardware Service
- U-Prox IP Web Service
  and then launch the U-Prox client application.

To attach the databases, use the utilities from the archive att_det_bat_file_sqlexpress.rar, placing it in the database directory (by default — C:\Program Files (x86)\A2SoftIn\UProxIP\):

attach_all.bat — to attach databases to SQL Server
detach_all.bat — to detach databases before migration

Run both files with administrator privileges (Run as Administrator).
After attaching, the utility will generate a log file named attach_all.log, in which will indicate that the databases have been updated to SQL Server 2016/2019/2022.

Rules and recommendations for installing and configuring SQL server for U-PROX ACS

If errors occur during the automatic installation of MS SQL Server, it can be installed manually.
The SQL Server configuration must meet the requirements of the U-Prox software, as described in the “Installation Rules” section of the installation wizard or in the Readme.ua.htm and ManualyInstall.SQL.ua.htmlfiles on the installation disc.

Attention!
For proper operation, the MS SQL Server instance service (2014–2022) must run under the local system account(SYSTEM, NT AUTHORITY\SYSTEM).

Installing SQL server:

when installing SQL – there should be standard settings, including “Windows authentication”

screenshot – for an example of installing 2019 SQL:

after installation – for correct operation, the MS SQL Server 2014 – MS SQL Server 2022 instance service must be run as the local system user (SYSTEM, NT AUTHORITY\SYSTEM).”

Start the Windows services window: – “Start” – “Run” – services.msc

find the “SQL Server (SQLEXPRESS)” service – the basic name of the instance, go to the service properties and set the required parameter, and then restart the service

after installation – configure all SQL protocols as specified in point #1 on the “FAQ” page of our website

Example:

To launch the SQL Server Configuration Manager window from the console, use the following lines:

for 2014 SQL: C:\Windows\SysWOW64\mmc.exe /32 C:\Windows\SysWOW64\SQLServerManager12.msc

for 2016 SQL: C:\Windows\SysWOW64\mmc.exe /32 C:\Windows\SysWOW64\SQLServerManager13.msc

for 2017 SQL: C:\Windows\SysWOW64\mmc.exe /32 C:\Windows\SysWOW64\SQLServerManager14.msc

for 2019 SQL: C:\Windows\SysWOW64\mmc.exe /32 C:\Windows\SysWOW64\SQLServerManager15.msc

for 2022 SQL: C:\Windows\SysWOW64\mmc.exe /32 C:\Windows\SysWOW64\SQLServerManager16.msc

Enable the specified protocols and configure them, and then restart the “SQL Server (SQLEXPRESS)” service

In the TCP/IP protocol properties, on the “IP Addresses” tab under the “IPAll” section, set the “TCP Port” value to 1433, then restart the “SQL Server (SQLEXPRESS)” service.