Question & Answer
Question
How do you move the Reports database from Microsoft SQL Server Data Engine (MSDE) to a Standard or Enterprise SQL Server?
Answer
Contents
Problem
How do you move the Reports database from Microsoft SQL Server Data Engine (MSDE) to a Standard or Enterprise SQL Server?
Solution
Problem
How do you move the Reports database from Microsoft SQL Server Data Engine (MSDE) to a Standard or Enterprise SQL Server?
Solution
- Stop the TeaLeaf Report Data Collector service on the TeaLeaf Report Server.
- Connect to the TL_Reports database on that server (the MSDE version) from another SQL Server that has SQL Enterprise Manager installed.
- Detach that database.
- Move the MDF and LDF files of the TL_Reports database to the new server.
- Create a user called TLADMIN on the new server.? The password is the TeaLeaf-specific one.? Check with IBM Tealeaf Customer Support for the password.
- Attach the database on the new servers using the MDF or LDF files and assign the TLADMIN user as the owner. The following SQL statements also need to be run to link the login userid to the database userid:
USE TL_REPORTS
GO
EXEC sp_change_users_login 'Update_One' 'TLADMIN' 'TLADMIN'
GO - Open the ReportConfig.exe utility on the TeaLeaf Report Server (under Start --> Programs --> TeaLeaf Technology --> TeaLeaf Reports) and modify the settings on the Database tab to refer to the new SQL server.
- Click OK to save the changes.
- Restart the TeaLeaf Report Data Collector service and check the NT Application log for any errors.
Contact?IBM Tealeaf Customer Support for any questions or problems.
Article Reference
00000115
"
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSERNK","label":"Tealeaf Customer Experience"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
08 December 2018
UID
ibm10776587