Error: "Cannot open database "NetWrix_File_Server_Change_Reporter" requested by the login. The login failed. Login failed for user 'sa'."

Error Cannot open database NetWrix_File_Server_Change_Reporter requested by the login failed for user 'sa'
KB1494 | Last review: Sep 27, 2017 | Netwrix Auditor for File Servers | 3.3 and above
Email It to Me Print this Page
Symptoms The product returns the following error: "Cannot open database "NetWrix_File_Server_Change_Reporter" requested by the login. The login failed. Login failed for user 'sa'."
Cause The password of 'sa' user has expired.
Resolution

To solve the issue, make sure that the "sa" login is enabled, and that the "sa" password has not expired. Do the following:

  1. Navigate to Start / All Programs / Microsoft SQL Server / SQL Server Management Studio and log in as a local administrator with a trusted connection.
  2. In the left pane, navigate to Security / Logins / sa. Right-click it and select Properties. 
  3. In the Login Properties dialog, in the left pane navigate to the Status page.
  4. Make sure that the Enabled option is selected under Login.
  5. Switch to the General page and make sure that the Enforce password expiration option is deselected.
  6. Click OK to save the changes.
Was this information helpful?