7920: Acronis Backup & Recovery 10 Fails to Update Acronis Management Server Due to Insufficient Microsoft SQL Server User Rights

Last update: 22-04-2012

Assign the SQL user administrator rights and reattempt the installation

This article applies to:

  • Acronis Backup & Recovery 10 Advanced Server
  • Acronis Backup & Recovery 10 Advanced Server - Small Business Server Edition
  • Acronis Backup & Recovery 10 Advanced Workstation
  • Acronis Backup & Recovery 10 Advanced Server - Virtual Edition

Symptoms

  1. During the first installation of the Acronis Management Server you have specified to use an existing local or remote Microsoft SQL Server;
  2. When attempting to update the Acronis Management Server to the latest build, the installation rolls back;
  3. In the MSI log you see the error entries similar to the following ones:

    (!) For information on how to get the installation log and analyze it please see Creating an MS Installer Log of Acronis Software and Analyzing Installation Logs of Acronis Products Based on MSI Technology.

    1: MSIGEN:Database installer: Query 'SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1) FROM master.sys.master_files WHERE database_id = 1 AND file_id = 1' didn't return any record.
    Additional Info:
    --------------------
    Error code: 1
    Module: 0
    LineInfo: 60ae23eb1e04dfd7
    Fields:
    Message: Query 'SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1) FROM master.sys.master_files WHERE database_id = 1 AND file_id = 1' didn't return any record.

Cause

The Microsoft SQL Server user that you specify when attempting to update the Acronis Management Server does not have administrator rights. For example, the user only has the db_owner role.

Solution

Assign the Microsoft SQL Server user administrator rights (at least for the course of installation). Reattempt the installation.

More information

See also Acronis Backup & Recovery 10 Fails to Update Acronis Management Server or Acronis Storage Node to Build 11345.

Tags: