Roger VISO and SQL Server Express 2022 setup
Software used in this video:
Windows 11 Pro 23H2 22631.3880
Roger VISO v2.0.8.36183
Roger VDM v2.0.8.35278
Roger SVC v2.0.8.36183
Microsoft® SQL Server® 2022 Express
Microsoft® SQL Server Management Studio (SSMS) 20.2
•••
VISO ST software is a Windows application for configuration and management of RACS 5 ST access control and building automation system. The standard version (RACS 5 ST) managed by VISO ST software offers both typically expected access control features and advanced functionalities beyond the popular access control. RACS 5 ST is dedicated to medium and big installations, also distributed ones, where subsystems are connected to a central system in a wide area network (WAN). VISO ST is offered free of charge in the starter version and can support up to 16 doors and 500 users. In the case of installations exceeding the starter version of VISO ST, a base license (VISO BASE ST) is offered. This version supports up to 32 doors and 1000 users. The VISO ST base license can be extended by purchasing licenses for individual functionalities. VISO BASE ST can handle a maximum of 128 doors, and for installations exceeding these parameters, the advanced version of VISO EX is offered.
https://www.roger.pl/en/products/racs...
•••
Key Notes:
• Procced with Basic Install of SQL Server 2022
• Install SQL Server Management Studio (SSMS)
• Navigate to: SQL Server Configuration Manager (Local) / SQL Server Network Configuration / Protocols for SQLEXPRESS, to enable all available protocols.
• Navigate to: SQL Server Configuration Manager (Local) / SQL Server Services, to start the "SQL Server (SQLEXPRESS)" service.
• Use VISO software to create a new access control database.
• Use SSMS to enable "sa" user.
• Use SSMS to set SQL Server to use Mixed Mode/SQL Authentication.
• Open Roger SVC and enter the credentials for the "sa" user.
• Open VISO to add the localhost as the communication Server.
• Create a Restricted Windows User Account.
• Make sure that the Restricted User has write access to the "C:\Program Files\ROGER" folder.