Veeam backup installed in our Virtual environment to backup all the Virtual machines. The virtual machine with sql server throws the error during backup.
Failed to inventory guest system: Cannot get host information. Cannot collect host info. Microsoft SharePoint farm topology collector process is failed with exit code -1 Win32 error:The operation completed successfully. Code: 0
The Service account used for veeam backup should be given a sysadmin role in the sql servers.
Enable the sysadmin role for the backup user.
Windows domain: DOMAIN
Backup user: veeam service account
SharePoint SQL database: SHAREPOINT
SharePoint SQL database service: MSSQL $ SHAREPOINT
open an administrative command prompt (cmd):
Stop SQL Server service:
net stop MSSQL $ SHAREPOINT
SQL Server in single user mode start:
net start MSSQL $ SHAREPOINT / m SQLCMD
Type SQL commands in the SQL command line:
sqlcmd-S. SHAREPOINT
USE [master];
CREATE LOGIN [DOMAIN veeam service account ] FROM WINDOWS WITH DEFAULT_DATABASE = [master];
EXEC sp_addsrvrolemember ‘DOMAIN admin’, ‘sysadmin’;
GO
QUIT
Restart SQL Server:
net stop MSSQL $ SHAREPOINT
net start MSSQL $ SHAREPOINT