Important Update: Cohesity Products Knowledge Base Articles
All Cohesity Knowledge Base Articles are now managed via the Cohesity Support Portal: https://support.cohesity.com/. The Knowledge Base articles available here will not reflect the latest information or may no longer be accessible.
Problem
After transferring SQL logins and passwords to the destination SQL server, users may not be able to access the database.
Error Message
Event Category: Storage Online
Event ID: 13360
Description: An error was detected while accessing the Vault Database 'EVMBX01x2' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand)
Description: Cannot insert the value NULL into column 'IndexCommitted', table 'EVMBX01x2.dbo.JournalUpdate'; column does not allow nulls. INSERT fails.
SQL Command: uspu_Saveset_JournalUpdate
Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for SQL Server
Number: 0x80040e2f
SQL State: 23000
Native Error: 00000515
HRESULT 0x80040e2f
V-437-13360
Cause
Integrated Log-ons that have been granted access on a destination server in a different domain than the source server, cause orphaned users. Log-ons are associated to users by the security identifier (SID), and if the SID is inconsistent after moving a database, SQL Server may deny the user access to the database. If transferring Log-ons and passwords by using the SQL Server DTS Transfer Log-on feature, there will likely be orphaned users.
Solution
1. Open Query Analyzer on the destination SQL server, and then run the following query:
use enterprisevaultdirectory
exec sp_change_users_login 'Report'
2. If the Database Owner (DBO) Vault Service Account (VSA) is listed as orphaned, run this query:
use enterprisevaultdirectory
exec sp_changedbowner '<domain>\<VSA>'
Note: 'Replace <domain> with windows domain name and <VSA> with vault service account'.
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.