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:
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.
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.
- Open Microsoft SQL Server Management Studio and expand the Security node.
- Right click Logins and choose New Login.
- Use SCRIBE as the login name.
- Choose SQL Server Authentication.
- Specify the password as integr8!.
- Uncheck the Enforce password policy option.
- 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-PasswordIf you are still experiencing issues, contact TIBCO Scribe Support.
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"
Feedback
thumb_up
Yes
thumb_down
No