1. If you are migrating your databases, run the following SQL commands from SQL Management Studio to prepare the tl_reports table for migration.

   use tl_reports
   go
   declare @status int
   declare @message nvarchar(4000)
   declare @date datetime
   set @date = getdate()
   exec pr_LoadCalendar @date, @status output, @message output
   exec pr_LoadCalendarHour @date

2. Stop all services that make use of the databases, except for the Portal services.
3. Before you start the migration, Tealeaf services must be made aware of the change in SQL Server instances through TMS.

   Only the settings that apply to your specific Tealeaf solution must be updated.

4. Using TMS, navigate to the Shared configuration information node and update the following settings to reflect the new SQL Server environment:
   • Database Host Name
   • Report Database Port
5. Stop the Portal services.

1. Right-click the database name in Object Explorer.
2. Select Tasks > Back Up....
3. Under Source:
   • Database: <Database to be backed up>
   • Backup type: Full
   • Backup component: Database
4. Under Backup set:
   • Name: <Preferred backup name>
   • Description: (Optional)
   • Backup set will expire: After 0 days
5. Under Destination, remove any existing listed sets.
   Note: This step does not delete the set. It just removes it from the list.
6. Add a new set in a known location and with a known name. Add the .bak file type extension. For example:

   
   C:\tl_reports.bak
   

7. Under Select a page, select Options.
8. Select Back up to the existing media set.
9. Select Overwrite all existing backup sets.
10. Click OK.

The backup may take a while, depending on the size of the database.

1. Log in to the Report Server.
2. Navigate to the following directory:

   
   <install_directory>\Reporting
   

3. Start the Database Manager:

   
   TealeafDatabaseManager.exe
   

4. Enter the connection information for the new database.
   1. Authentication: You must use Windows Authentication or SQL Server Authentication to verify the database account.
   2. User name and Password: Enter the credentials for the administrator account that is used to connect to the new SQL Server instance.
   3. Reports Host: Enter the host server of the SQL Server instance hosting the new TL_REPORTS database.
   4. Port: Enter the port to use to connect. By default, this value is 1433.
   5. Port: Enter the port to use to connect. By default, this value is 1433.

   The Database Manager is opened.

5. Create an user:
   1. From the TDM menu, select User Management > Create User.
   2. Enter the credentials for the TLUSER account.
   3. Click OK.

   The user account is created.

   Note: If you receive an error message indicating that the account exists, then the account is properly configured, and you may continue with these steps.
6. Repeat the above steps to verify and, if necessary, create the TLADMIN account.

1. Right-click the Databases folder in Object Explorer.
2. Select Restore Database....
3. Under Source for restore:
   • Select From device.
   • Select the ... button to the right of the From device box.
   • Select Add.
   • Select the backup file for the current database. In the above example, it is C:\tl_reports.bak. Click OK.
   • Click OK to return to the Restore Database window.
4. Under Select the backup sets to restore, select the Restore check box to the left of the newly added backup.
5. Under Destination for restore, from the To database drop-down, select the name of the current database.
6. Under Select a page, select Options.
7. Select the check box next to Overwrite the existing database.
8. Under Restore the database files as, update the filegroups to reflect your filegroup paths.
9. Select Leave the database ready to use by rolling back uncommitted transactions.
10. Click OK.

The local definitions for user accounts must be updated to point to the new server hosting the databases. You can repair these user accounts through the Database Manager.

This command can be run multiple times without issues.

1. On the Report server, navigate to the following directory.

   
   <install_directory>\Reporting
   

2. Launch TealeafDatabaseManager.exe.
3. Connect to the databases.
4. The Database Manager is displayed.
5. From the Database Manager menu, select Mode > User Management > Repair Users.
6. To repair the TLADMIN and TLUSER accounts used to access each of your Tealeaf databases, click OK.