"Invalid column name 'UserCanonical'" error received during install/upgrade
ID: 184
Time: 2/2/09 15:11:56.496
Level: ERROR
Thread: 3124
Logger: NetProLib.Database.XdbCreator
File: .\XdbCreator.cpp
Function: NetProLib::Database::XdbCreator::_runScript
Line: 629
Message: Failed script 'NetPro-ChangeAuditor-Procedures.sql', cause "1) Invalid column name 'UserCanonical'.".
Watch attached video in Internet Explorer utilizing the Adobe Flash Player plug-in for further details and explanations.
To add a UserCanonical column: (Please read Additional Information below for Disclaimer)
1. Open SQL Management Studio
2. Navigate to Directory.User table through Databases | ChangeAuditor (or DB Name) | Tables | Directory.User
3. Right- Click on Columns. Select Design.
4. Add UserCanonical as a column, and set type to "udt_ad_canonical_name:nvarchar(1024)"
5. Close table and save.
6. Restart repo.
Quest does not provide support for problems that arise from improper modification of the SQL database.
The ChangeAuditor Repository utilizes Microsoft SQL Server 2005 or SQL Server 2005 Express Edition as the main database for collecting and reporting audit information. This
data needs to be protected and backed up on a regular basis, acceptable to your data retention policies. It is recommended to backup the database before making any changes to the database.There are several third-party tools available, including Microsoft's SQL Tools, which provide backup and restore functions.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center