#### Update the server name in the databases

Distributed System Note: Complete these steps on the Database Server.

To update the server name in the ION_Data, ION_Network, and ApplicationModules databases:

1. Open SQL Server Management Studio, select File > Open File, then select the `update_server_name_in_live_databases.sql` script in the `...\SBS Upgrade Package\SQL_Script_Files` folder.
2. Edit the script to provide the old and new server names.

3. Save the script and then click !Execute to update the server name in the databases.
4. Verify that the script worked by looking in ION_Data.dbo.Source table. The LOGINSERTER source should now show the new server name.

Note: For any archived databases, complete steps 1 to 3 above, but use the `update_server_name_in_archive_databases.sql` script instead. Repeat these steps for each archived database.