Failed to inventory guest system – Veeam backup

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

Post Comment

CommentLuv badge