Cannot open database error after moving SCRIBEINTERNAL database to new server

Cannot open database error after moving SCRIBEINTERNAL database to new server

book

Article ID: KB0078827

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight 7.9.2

Description

Issue:  I backed up the SCRIBEINTERNAL database from the TIBCO Scribe® Insight environment and restored the database to a new environment for testing.  When I run the Scribe InternalDB tool and test the connection to the Internal database, I receive a Database error similar to the following:

Error Number:  896
Description:  [37000] Cannot open database “SCRIBEINTERNAL” requested by the login.  The login failed.
Connection string Used: ‘Data Source =ScribeInternal_MS; User ID = SCRIBE; Password=**********’


kA232000000PDy3CAG_en_US_1_0

Resolution:
  1. Run the following SQL script against the SCRIBEINTERNAL database:
                    ALTER USER Scribe WITH LOGIN = Scribe
  1. Run the InternalDB tool.  Continue with the process to test the connection and “Update Server Name”.  Reference Step 5 of online help section “Creating a New Scribe Insight Server” for instructions.
For more information, see our video: Moving TIBCO Scribe® Insight Server

 

Issue/Introduction

After moving the Scribe Internal database to a new server, SQL errors display when testing the connection in the InternalDB tool.
Powered by Wolken Software