Description

In general, when installing Veritas System Recovery Manager, SQL Server Express Edition x64 is automatically installed. For any reason requiring a manual installation of a SQL Server instance for the Veritas System Recovery Manager, please see below steps.

1. Download Veritas System Recovery from Veritas Download Center.

2. Right-click the downloaded zip file for Veritas System Recovery install file and
2.1. Select the  Properties option 
2.2. Press the Unblock button if present.
2.3. Extract the zip file.

3. Install Veritas System Recovery using the Browser.exe  file.

4. Reboot the system.

-------------------------
NOTE 1:
Veritas System Recovery Manager is available without installing Veritas System Recovery, but a part of features is limited. Status is viewable and backup policies to Agents can be deployed without Veritas System Recovery, but View Console is unavailable.

To use View Console, Veritas System Recovery needs to be installed with Veritas System Recovery Manager. The Veritas System Recovery license is not needed on the machine with Veritas System Recovery Manager. The licenses need to be installed on each agent.
-------------------------

5. Double-click \SSR\SSRManager\Sqlexpress\SQLEXPR.exe.

6. Click New SQL Server stand-alone installation or add features to an existing installation.

7. Check I accept the license terms and Privacy Statement to accept the license agreement.

8. Click the Next button to proceed.

9. Click Next.

10. Uncheck SQL Server Replication.

11. Click Next.

12. Input VSREXPRESS in the Named instance: and Instance ID: fields.

13. Click Next.

14. Confirm the Startup Type for the SQL Server Database Engine and SQL Server Browser options is set to Automatic.

15. Click Next.

16. Confirm the Admin account for Veritas System Recovery Manager is added in the Specify SQL Server administrators field,

17. Click Next.

-------------------------
NOTE 2: If you would like to add a new Admin account after the Veritas System Recovery Manager installation completes, please perform the below Steps a to f.

a. Logon as an existing Admin account for Veritas System Recovery Manager.

b. Right-click the Start button.

c. Select the Windows PowerShell (Admin) option.

d. Run the command sqlcmd -E -S .\vsrexpress

e. Run the below command replacing with the actual domain or computer name where the account resides and replacing with the actual admin account. If the below command is successful, no error message is returned.

sp_addsrvrolemember '\','sysadmin'
go

f. Run the command exit

-------------------------

18. Click OK.

19, Click Close.

20. Double-click \SSR\SSRManager\Setup.exe.

21. Click Next.

22. Check I agree the terms in the License Agreement to accept the license agreement. 

23. Click Next.

24. Click Next.

25. Click Install.

26. Uncheck the Launch application option.

27. Click Finish.

28. Click Start -> Microsoft SQL Server 2019 -> SQL Server 2019 Configuration Manager.

29. In SQL Server 2019 Configuration Manager, click SQL Server Network Configuration -> Protocols for VSREXPRESS.

30. Enable the Named Pipes and TCP/IP options.

31. Click Apply.

32. Click SQL Server Services.

33. Right-click SQL Server (VSREXPRESS).

34. Click Restart and allow the service to restart.

35. Right-click SQL Server Browser.

36. , Click Restart and allow the service to restart.

37. Launch Veritas System Recovery Manager.