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
- During the first installation of the Acronis Management Server you have specified to use an existing local or remote Microsoft SQL Server;
- When attempting to update the Acronis Management Server to the latest build, the installation rolls back;
- 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.