B.2 VisualGroups script for Swyx Server migration
Use cases:
1 You have accidentally removed one of the users 'VG_license_user' or 'VG_status_user' in your Swyx Administration.
2. You have migrated the VisualGroups installation to another server, for example by changing the hardware or software of the Windows server.
Default behaviour: In both cases VisualGroups no longer works properly. In the second case, the system's encrypted passwords are no longer valid.
1 Stop the SwyxPLUS VisualGroups Reporting and Maintenance service.
2 Delete the users VG_license_user and VG_status_user in your Swyx Administration.
3 Delete the users VG_license_user and VG_status_user in your Swyx Administration.
4 Execute the following command via SQL Server Management Studio:
delete from [VisualGroups].[dbo].[svg_ta_globalsettings] where settingname like 'swyx%' or settingname like 'vgstatus%'
5 Log in with an administrator account at http://localhost/visualgroups/adminvg.aspx.
6 Start the SwyxPLUS VisualGroups Reporting and Maintenance service.
*The users VG_license_user and VG_status_user are reset and the function of the system is restored.