ENM8.2 installer fails on step "Backing up previous historical data" with error "data backup failed"

Tìm các câu hỏi thường gặp

Issue
When upgrading from an earlier version of ENM to ENM8.2 the installer fails on step "Backing up previous historical data" with error "data backup failed". On troubleshooting the log we see an error
"SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online"

Product Line
Event Notification Module (ENM) V8.2

Environment
Upgrade to ENM8.2 from ENM7.1 or ENM8.0

Cause
As the error states "xp_cmdshell" has been turned off as part of SQL server security configuration

Resolution
To resolve the issue, log in into SQL server management studio with sysadmin privileges. Open a new query window and run the below query:

-- show advanced options 
EXEC sp_configure 'show advanced options', 1
GO RECONFIGURE GO 
-- enable xp_cmdshell 
EXEC sp_configure 'xp_cmdshell', 1
GO RECONFIGURE GO 
-- hide advanced options 
EXEC sp_configure 'show advanced options', 0
GO RECONFIGURE GO

Once the query has run successfully, close out of SQL server management studio and rerun the installer.