Description

Introduce how to change SQL instance from SQL Express 2014 (32bit) to SQL Express 2017 (64bit) or later on DLO server. Follow the below steps.

1. Identify your DLO install path. 

Note:
If it is different from the default install path "C:\Program Files\Veritas\Veritas DLO", perform the below Step 30 and 32 with your path.

2. Run Services.msc. Double-click "SQL Server (DLO)", and click "Log On" tab. Verify your account that will be used in Step 12 and/or later.

3. Stop the below services, and change the startup type to "Disabled".

 Mindtree StoreSmart Dedupe Server
 Veritas DLO Administration Service
 Veritas DLO Maintenance Service
 Veritas DLO Edge Server
 Veritas DLO Web Server

4. Open [Control Panel].

5. Click [Uninstall a program].

6. Click [Microsoft SQL Server 2014] and click [Change].

7. Click [Remove].

8. Select [DLO] in [Instance to remove features from:], and click [Next].

9. Check [Database Engine Services], and click [Next].

10. Click [Remove].

11. Confirm that "Database Engine Services" is "Succeeded", and click [Close].

12. Reboot the machine, and log on as your account in Step 2.

13. Run SQLEXPR.exe for SQL version that you would like to install. 

14. Click [New SQL Server stand-alone installation or ...].

15. Check [I accept the license terms], and click [Next].

16. Click [Next].

17. In Feature Selection screen, uncheck [SQL Server Replication], and click [Next].

18. Input "DLO" in [Named instance] box, and click [Instance ID:], and confirm "DLO" is input, and click [Next].

19. Click [Account Name] box in [SQL Server Database Engine], and click [Browse].
 Input your account in Step 2, and click [Check Name], and click [OK].

20. Click [Password] box in [SQL Server Database Engine], and input your password.

21. Change the startup type for [SQL Server Browser] from Disabled to Automatic. Confirm that the startup type for [SQL Server Database Engine] is Automatic.

22. Click [Next].

23. Confirm [Windows authentication mode] is checked, and your account in Step 2 is added in [Specify SQL Server administrators].

24. Click [Next].

25. Confirm that the following items are Succeeded, and click [Close]. Close the SQL installation wizard.

 Database Engine Services
 SQL Browser
 SQL Writer
 Setup Support Files

26. Click [Start] [Microsoft SQL Server 2017] [SQL Server 2017 Configuration Manager].

27. Expand [SQL Server Network Configuration], and click [Protocol for DLO].
 Double-click [Named Pipes], and change [Enabled] from [No] to [Yes], and click [Apply] [OK].
 Double-click [TCP/IP], and change [Enabled] from [No] to [Yes], and click [Apply] [OK].

28. Click [SQL Server Services], and right-click [SQL Server (DLO)], and click [Restart].

29. Right-click [Start] and click [Run], and input "cmd", and click [OK].

30. Run below.

sqlcmd -E -S .\DLO

EXEC sp_attach_db DLO,"C:\Program Files\Veritas\Veritas DLO\Data\DLO.mdf","C:\Program Files\Veritas\Veritas DLO\Data\DLO_log.ldf"

GO

EXEC sp_attach_db dedupedb,"C:\Program Files\Veritas\Veritas DLO\Dedupe\Database\dedupedb.mdf","C:\Program Files\Veritas\Veritas DLO\Dedupe\Database\dedupedb_log.ldf"

GO

Exit

Exit

31. Right-click [Start] and click [Run], and input "cmd", and click [OK].

32. Run below.

cd "C:\Program Files\Veritas\Veritas DLO"

sqlcmd -E -S .\DLO -dmaster -iDLODBInstallXSP.sql -o XSP.log

33. Copy XPDLOShareU_x64.dll from to "C:\Program Files\Microsoft SQL Server MSSQL14.DLO\MSSQL\Binn"

34. Rename the copied XPDLOShareU_x64.dll file in "C:\Program Files\Microsoft SQL Server\MSSQL14.DLO\MSSQL\Binn" to XPDLOShareU.dll

35. Change the startup type for the below services to Automatic, and click [Apply] [OK].

 Mindtree StoreSmart Dedupe Server
 Veritas DLO Administration Service
 Veritas DLO Maintenance Service
 Veritas DLO Edge Server
 Veritas DLO Web Server 

36. Reboot the machine, and confirm that the below services are running.

 Mindtree StoreSmart Dedupe Server
 Veritas DLO Administration Service
 Veritas DLO Maintenance Service  
 SQL Server (DLO)
 SQL Server Browser 

35. Confirm DLO console is launched successfully.

36. Log on to clients, and confirm DLO Desktop Agent works successfully.