To protect SQL Server 2012 or SQL Server 2014, the following must be done. Login to SQL Server Management Studio Add the system account NTAuthoritySystem to the Sysadmin group on SQL Server DPM cannot protect databases that are stored on remote SMB stores Availability group replicas are configured as read-only When you perform an alternate […]
Continue reading
To protect SQL Server 2012 or SQL Server 2014, the following must be done. Login to SQL Server Management Studio Add the system account NTAuthoritySystem to the Sysadmin group on SQL Server DPM cannot protect databases that are stored on remote SMB stores Availability group replicas are configured as read-only When you perform an alternate […]
Continue reading
I hit an issue on launching the DPM reporting. The DPM is functioning well except the reporting. It’s the issue of the SQL Reporting settings. It stated as : An error has occurred during report processing. (rsProcessingAborted).Query execution failed for dataset ‘DataSet2’. (rsErrorExecutingCommand)Invalid object name ‘vw_DPM_Replica’. Steps taken to resolve : Launch the Reporting Services […]
Continue reading