TIBCO Scribe® Insight error during SCRIBEINTERNAL database creation: "Error Opening data source OleDBAdapter.Database (ScribeInternal_MS1) Error 104"

TIBCO Scribe® Insight error during SCRIBEINTERNAL database creation: "Error Opening data source OleDBAdapter.Database (ScribeInternal_MS1) Error 104"

book

Article ID: KB0074715

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight -

Description

An error is received while attempting to create the SCRIBEINTERNAL database: "Error Opening data source OleDBAdapter.Database (ScribeInternal_MS1) Error 104".

The above error is thrown because the database creation process was unable to create the SQL Server user SCRIBE. During the creation process the SQL user is supposed to be created and assigned a default password "integr8!". A common reason that the SCRIBE user was unable to be created is the default password did not meet the requirements of the password enforcement policy in place on the SQL Server.

Issue/Introduction

During the TIBCO Scribe Insight installation an error is received during the creation of the SCRIBEINTERNAL database: "Error Opening data source OleDBAdapter.Database (ScribeInternal_MS1) Error 104"

Resolution

Resolve the issue by manually creating the SCRIBE user in Microsoft SQL Server Management Studio before creating the SCRIBEINTERNAL database.

Steps to manually create the SCRIBE user.
  1. Open Microsoft SQL Server Management Studio and expand the Security node.
  2. Right click Logins and choose New Login.
  3. Use SCRIBE as the login name. 
  4. Choose SQL Server Authentication.
  5. Specify the password as integr8!.
  6. Uncheck the Enforce password policy option.
  7. Click OK when finished.
After the user is created in Microsoft SQL Server Management Studio, create the SCRIBEINTERNAL database again through the TIBCO Scribe Insight setup wizard. If you want to change the password for the SCRIBE user to meet your organizations requirements, see this article for information. https://support.tibco.com/s/article/Changing-the-Scribe-Internal-Database-Default-User-and-Password

If you are still experiencing issues, contact TIBCO Scribe Support. 
Powered by Wolken Software