What's New in Retrospect – Retrospect Backup 19 + Retrospect Virtual 2022 + Retrospect Cloud Storage

Microsoft SQL - Authentication Fails in Retrospect 7.6 and later (Windows)

Top Articles



title: Microsoft SQL - Authentication Fails in Retrospect 7.6 and later (Windows) created_at: 2012.02.13 updated_at: 2020.03.25 category: Top Articles platforms: Windows ---

Retrospect requires SQL-DMO components that are not automatically installed with SQL 2008 and later. Without the required Microsoft configuration, Retrospect will report authentication failures when trying to license the databases under Configure>volumes.

To fix the problem, users need to download and install the "Microsoft SQL Server 2005 Backward Compatibility Components" package to the Server running SQL Server 2008 and later.

Installation Instructions

  1. Contact Support for a download link for the x86 installer or the x64 installer, depending on your configuration.

  2. Install the Microsoft SQL Server 2005 Backward Compatibility Components.

  3. Open Retrospect and go to Configure>Volumes. Right click on your SQL server and select License to apply your SQL license and authenticate to the server.


Last Update: 25 March, 2020