Adobe Connect behaves unexpectedly after computer name changes

Last updated on May 15, 2021

Issue

Adobe Connect behaves unexpectedly after you moved your Connect server to new hardware with a different computer name.

Run the script below to change the database. This solution assumes that the database is on a separate server, and you are using the same FQDN.

Back up the database, content directory, Custom.ini, and any extra or customized files.
While the current server is still up, record the results of the following query from the breeze database.

SELECT HOST_ID FROM PPS_ENUM_DATA_HOSTS WHERE STATUS = 'A'

Stop the Connect and FMS services on the current (old) server. You can now bring this server off line.
Update DNS / Host entries to point to the new server's IP.
Get the name of the new Connect server by right-clicking My Computer and choosing Properties.
Run the following SQL code on the breeze database. Making sure to enter the number you recorded from step2 as the @Host_ID, and the new server name as @NewServName. For New Server Name (on line 4), enter the name of the computer you're moving the server to.

DECLARE @OldServerName NVARCHAR(64), @NewServName NVARCHAR(64)

DECLARE @Host_id INT

SET @Host_id =1

--Put the number from Step 1 here.

SET @NewServName = 'New_server_Name'

--Put new server name between quotes

SET @OldServName = (SELECT [NAME] FROM PPS_ENUM_DATA_HOSTS WHERE [HOST_ID] = @HOST_ID)

UPDATE PPS_ENUM_DATA_HOSTS

SET [NAME] = @NewServName

WHERE [HOST_ID] = @HOST_ID

Install Connect on the new Server. If prompted, do not start the services yet. If you started them by accident, stop them.

Copy the custom.ini from the backup you made in step 1.
Copy the Content directory from the backup you made in step 1.
Place any extra or customized files back in place (jar files, xml files, and so on.) from the backup you made in step 1.

Unexpected behavior occurs in Adobe Connect if your computer name changes because Connect interprets the name change as a new host.

New user?