Error Message

Case1: Fresh Installation with Remote SQL 2019 instance

When installing Veritas DLO in a Remote DB setup with SQL 2019 Server as SQL DB component, once the installation completes, Launch of DLO Administrator Console fails with below error.

Case 2: For Upgrade Installation with remote SQL 2019 instance

When upgrading to Veritas Desktop and Laptop Option from any previous supported version, in a Remote SQL DB setup having SQL 2019 Server as DB component. DLO database version will not get upgraded and it still shows the old version as highlighted in the below.

After the Upgrade installation completes, Launch of DLO Administrator Console fails with below error.

Steps to resolve this issue:

Case 1: For Fresh Installation with Remote SQL 2019 instance

From the Command prompt in the remote SQL DB machine run the below commands:

• osql.exe -E -l 60 -S .\ -d DLO -n -i "C:\Program Files\Veritas\Veritas DLO\DLODBUpgrade.sql" -o "%TEMP%\DLODBUpgrade3.0To3.1.log"

• osql.exe -E -l 60 -S .\ -d master -n -i "C:\Program Files\Veritas\Veritas DLO\DLODBInstallXSP.sql" -o "%TEMP%\DLODBInstallXSP.log"

Add Dedupe admin user to user_info table: -

• osql.exe -E -l 60 -S .\ -d dedupedb -Q "UPDATE dbo.user_info SET role_id=5, user_name='', enc_password=NULL, is_domain_user=1 WHERE user_name='dedupemgr'" -o "c:\Program Files\Veritas\Veritas DLO\Dedupe_RemoteDB_Account_update.log"

Set 'sysadmin' server role to SQL user

• osql.exe -E -l 60 -S .\ -d dedupedb -Q “EXEC sp_addsrvrolemember , sysadmin” -o "c:\Program Files\Veritas\Veritas DLO\Dedupe_SetAdmin_SrvRole.log"

Case 2: For Upgrade Installation with remote SQL 2019 instance

From the Command prompt in the remote SQL DB machine run the below commands:

• osql.exe -E -l 60 -S .\ -d DLO -n -i "C:\Program Files\Veritas\Veritas DLO\DLODBUpgrade.sql" -o "%TEMP%\DLODBUpgrade3.0To3.1.log"
• osql.exe -E -l 60 -S .\ -d master -n -i "C:\Program Files\Veritas\Veritas DLO\DLODBInstallXSP.sql" -o "%TEMP%\DLODBInstallXSP.log"

Once above-mentioned scripts are executed, restart the SQL Server service, Veritas DLO Administration Service and Mindtree StoreSmart Dedupe Server service. Re-launch Veritas DLO Console.

Post installing, run the SQL scripts as mentioned in the below steps in the Remote SQL DB machine.

Note: This is applicable for DLO versions 9.3.3 and above when used with SQL 2019 as a remote database instance.