Overview
This article provides the steps to fix an issue that may occur when adding a Microsoft SQL-based Archive Store.
Information
When attaching a Microsoft SQL-based archive, the store creation process fails with the following error:
Failed during: Creating Archiving User
Details: ConnectionFailed
Root Cause Analysis
By default, the minimum password length requirement is 7 characters, but if the password requirement has been increased beyond this in the domain, the creation of the database in Microsoft SQL server will fail.
Diagnosis
The following error may be found in the ..\GFI\Archiver\Store\DebugLogs\ManagementProviders.log
file:
"error ","ManagementProviders","Error: (MSSql) CreateUser(). Error execute:
; message: Password validation failed. The password does not meet Windows policy requirements because it is too short."
Solution
Note: When upgrading to a newer version of GFI Archiver, the installation files mentioned in this procedure will be overwritten with the default versions, making the changes void and ineffective. Therefore, we suggest to keep a record of this procedure and follow it once again directly after upgrading, to keep this functionality intact.
Warning: This procedure requires to edit files manually. If the files are modified incorrectly, it can leave the server in a non-operational state. Please create backups of any file that is edited throughout this procedure before saving any changes to them.
- Open the
..\GFI\Archiver\Store\Data\Product.Config
file with Notepad. - Add the following 2 lines after the
<appSettings>
line (line 2 by default):<add key="PasswordMinLength" value="10" />
<add key="PasswordMaxLength" value="16" />
- Edit the lines added to have it match your domain's password requirements.
- Save the settings.
- Restart the GFI Archiver Store service.
- Try adding the store again.
Confirmation
The archive store is added successfully.