IBM Support

Cannot log into the Portal after a Database restore.

Question & Answer


Question

Cannot log into the Portal after a Database restore.

Answer

Contents
Problem
Cannot log into the Portal after a Database restore.? The following error is raised in the TLDataService log file:
<TIMESTAMP>DbConnector.PrimeDatabase ERROR StatisticsDB Error: Cannot open database "TL_STATISTICS" requested by the login. The login failed.? Login failed for user 'TLUSER'.

When you restore a Microsoft SQL Server database on a different machine you cannot access the database until you fix the permissions.

Solution

The steps below are performed as a Database (DB) Admin user:

1.? Be sure that this is the problem.? Run a command to list orphaned users:
EXEC sp_change_users_login 'Report'

2.? If the TLADMIN and TLUSER users are listed you can correct this issue by running the commands below:
USE TL_SYSTEM
EXEC sp_change_users_login 'Auto_Fix' 'TLADMIN'
EXEC sp_change_users_login 'Auto_Fix' 'TLUSER'

3.? Repeat these steps for all the Tealeaf databases:
USE TL_REPORTS
EXEC sp_change_users_login 'Auto_Fix' 'TLADMIN'
EXEC sp_change_users_login 'Auto_Fix' 'TLUSER'

USE TL_STATISTICS
EXEC sp_change_users_login 'Auto_Fix' 'TLADMIN'
EXEC sp_change_users_login 'Auto_Fix' 'TLUSER'


and so on...
Article Reference
00001162
"
[{"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":""}}]

Document Information

More support for:
Tealeaf Customer Experience

Software version:
All Versions

Document number:
776925

Modified date:
08 December 2018

UID

ibm10776925

Manage My Notification Subscriptions

Page Feedback