Moving the LobbyCentral Database
- All users must log off.
- Shut down all kiosk stations and QMonitor devices.
- Back-up the lobbycentral database.
- Restore database to new server.
- Reset the lobbyCentral database user account.
- Update the configuration files for the application and Windows service.
Preparing the Move
When setting up the new SQL Server, be sure that Mixed Mode is selected as the authentication method.
- Ensure all users have closed open tickets and logged out of LobbyCentral.
- Shut down all Kiosk, QMonitor, and iPad applications.
- Stop the LobbyCentral Windows Service.
The recommended recovery model for the database is Simple. If you choose Full Recovery, you must create a backup plan for both data and transaction log. It is recommended to run the plan hourly to keep the transaction log truncated.
Backing up and Restoring the LobbyCentral Database
You will be backing up two databases: lobbyCentral and lobbyCentral_chat. If you are on a version older than 6.0, you may not have the lobbyCenral_chat database in which case, you can skip those steps.
- Open SQL Management Studio (2008 or higher) and connect to the lobbycentral database server.
- Expand databases and right click the lobbycentral database.
- Click Tasks, then Backup
- The Destination of the backup should default to Disk with a default filepath and name. Click Remove, then Add if you want to change the backup location to a shorter path.
- Click OK.
- Copy the backup file to the destination server. Note that backup files are saved on the SQL server.
- Disconnect from source server and connect to the destination server.
- Right click Databases and choose Restore Database.
- Under Source, select Device.
- Click the file browser button.
- Ensure the Backup media type is File then click Add.
- Select the backup file and click OK.
- Under Backup Sets to Restore, check the Restore checkbox next to the most recent backup set.
- Click Files in the left menu.
- Verify that the drive in Restore As exists on the new server. For example, if the old server stored SQL files on the D drive, then the new server must have a D drive or you will need to change the restoration location.
- Click OK.
If the restore operation is successful, you must now reset the LobbyCentral db user account. Do not skip this step!
Resetting the LobbyCentral DB Account
When a backup operation is performed, it also backs up the db user accounts associated with that database. However, the db user information is stored in the master table and is not transferred to the new server. Therefore, the user accounts become orphaned on the new server.
To fix this, you must delete the orphan account and recreate it so that it exists on the new server.
- Right-click Databases and choose Refresh.
- Expand the lobbyCentral database
- Expand Security, Users
- Delete the lobbyCentral or lobbyCentralUser account. Make note of which name was used.
- At the root level of the server, expand Security, Logins.
- Verify that lobbyCentral or lobbyCentralUser does not exist. If it does, delete it.
- Right click Logins and choose New Login.
- In Login Name, type in the name from step 4.
- Select SQL Server Authentication.
- Type in a strong password.
- Uncheck Enforce Password Policy
- Click User Mapping in the left menu.
- Check the Map box next to lobbyCentral.
- In Database role membership, check the box next to db_owner
- Click OK.
It is recommended that you verify that the database user account can connect to the database. To do this, disconnect all servers in SQL Management Studio and click Connect. Select the destination server and change the authentication mode to SQL. Use the database account and password from step 8 and click Connect.
If a connection cannot be made, verify that the password has been entered correctly. You can also reset the password under Security->Logins.
Updating the LobbyCentral Configuration Files
The final step is to update the LobbyCentral web and service configuration files to use the new database server.
The default lobbyCentral location is:
- Windows 32-bit: c:\program files\fuhr software\lobbycentral
- Windows 64-bit: c:\program files(x86)\fuhr software\lobbycentral
- Open lobbycentral\web\CustomerSettings.config in Notepad.
- Locate the dbServer property and change the value to the new server. Important: do not forget the instance name if it is a Named Instance. i.e. SERVER\INSTANCE_NAME
- Verify that the dbUsername matches the one used in step 8 above.
- Change the dbPassword to the one created for the dbUsername account.
- Save the file and exit.
If you are using LobbyCentral version 6.1 or higher, the configuration file may be encrypted. Click here for instructions on how to decrypt the configuration file.
- Open lobbycentral\server\LobbyCentralService.exe.config in Notepad.
- Locate the dataSource property and change the value to the new server. Important: do not forget the instance name if it is a Named Instance. i.e. SERVER\INSTANCE_NAME
- Verify that the userID matches the one used in step 8 above.
- Change the password to the one created for the userid account.
- Save the file and exit.
- Open Windows Services and start the LobbyCentral service.
If the service fails to start, verify that the server, username, and password in the config file are correct. You can check the log file in lobbycentral\logs\server for the exact error.
If the error says "could not find or connect to SQL server" it means that the dataSource name is incorrect. If the error says "invalid login for user <username>" the username or password is incorrect.
Other Files to Update (if in use)
It is necessary to update the configuration files for other LobbyCentral applications if they are in use. The table below shows the configuration files associated with each application.
|API Service||\lobbycentral\API Service\web\web.config|
|Appointment Broker||\lobbycentral\Appt Broker\CustomerSettings.config|
Default Instance: The default or unnamed SQL Server instance. To access the default instance, you use the name of the server. i.e. MYSERVER
Named Instance: A SQL Server instance that is accessed by using the name of the server plus the instance name. i.e. MYSERVER\SQLSERVER
dbo: Database Base Owner. A permission that grants the assigned user ownership rights to the database. The dbo can perform all operations and table maintenance on the database.
dbo_owner: The dbo role assigned to the user under Security->Logins->User Mapping
sa: System Administrator database account. This is the default account created when the SQL instance is running in Mixed Mode. The sa account has full permissions and can access any database. It should only be used when performing server operations and not for application connectivity.
Mixed Mode: The mode that allows users to connect either by Windows Authentication or SQL Authentication. A SQL instance can be changed to Mixed Mode by editing the Security properties of the server. LobbyCentral requires Mixed Mode.