Unable to update the Deep Security Manager DB Schema when Microsoft SQL Server was not installed on C:\ drive

- Updated:
- 25 Aug 2017
- Product/Version:
- Deep Security 10.0
- Deep Security 10.1
- Deep Security 9.6
- Platform:
- Windows 2003 Enterprise
- Windows 2003 Enterprise 64-bit
- Windows 2003 Server R2
- Windows 2003 Standard
- Windows 2003 Standard 64-bit
- Windows 2008 Datacenter 64-bit
- Windows 2008 Enterprise
- Windows 2008 Enterprise 64-bit
- Windows 2008 Server R2
- Windows 2008 Server R2 Datacenter
- Windows 2008 Server R2 Enterprise
- Windows 2008 Standard
- Windows 2008 Standard 64-bit
- Windows 2012 Datacenter R2
- Windows 2012 Enterprise
- Windows 2012 Enterprise R2
- Windows 2012 Server Essential R2
- Windows 2012 Standard R2

Summary

The following DB Migration Tool logs may appear when updating the Deep Security Manager (DSM) Database (DB) Schema:

2016-Oct-24:09:27:34 [+01]	INFORMATION	Assembly Version [1.0.0.0], File Version [1.0.0.4], Compile Time [2016-Aug-24-14:28:16]  2016-Oct-24:10:17:50 [+01]	INFORMATION	SQLCMD search directory [C:\Program Files\Microsoft SQL Server\]  2016-Oct-24:10:17:50 [+01]	INFORMATION	getSQLCmdPath -> No files at [C:\Program Files\Microsoft SQL Server\]  2016-Oct-24:10:18:03 [+01]	INFORMATION	installDependencies -> SQLCMD search directory [C:\Program Files\Microsoft SQL Server\]  2016-Oct-24:10:18:03 [+01]	INFORMATION	installDependencies -> No files at [C:\Program Files\Microsoft SQL Server\]

Details

The issue happens because the SQLCMD.exe is installed in a path other than C:\Program Files\Microsoft SQL Server\.

To successfully use the DB Migration Tool, recreate the same installation path under C:\ drive:

Duplicate the folder containing the SQLCMD.exe file to the folder where migration tool is searching (C:\ drive).
For example, if the SQLCMD.exe file is under D:\Program Files\Microsoft SQL Server\100\Tools\Binn, create C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.exe.
Copy everything under D:\Program Files\Microsoft SQL Server\100\Tools\Binn\ to C:\Program Files\Microsoft SQL Server\100\Tools\Binn.
Relaunch the DB Migration Tool and then update the Deep Security Manager DB Schema.