Aegis 2.2 install or upgrade fails when installing the IQRM database. (NETIQKB73040)

  • 7773040
  • 15-Jun-2011
  • 15-Jun-2011

Environment

NetIQ Aegis 2.2

Situation

Aegis 2.2 install or upgrade fails when installing the IQRM database, with no error given.
sqlcmd was not found in this environment
ERROR2011-06-13 02:17:21 ? sqlcmd was not found in this environment.

Resolution

To resolve this issue, please do one of the following:

  1. Remove one of the version of Microsoft SQL Server Native Tools from the installation machine (not the target machine to receive the database)
  2. Execute the NetIQ Aegis 2.2 installer directly on the SQL server that will host the Aegis databases.
  3. Download the proper version of SQLCMD.exe for Microsoft SQL 2008 Server and place it in the following path on the installation machine:

    • C:\Program Files\Microsoft SQL Server\100\Tools\Binn\

  4. Execute the the NetIQ Aegis 2.2 Setup once again

Cause

When installing or upgrading the Aegis and IQRM databases to NetIQ Aegis 2.2 remotely, the installer fails if both Microsoft SQL Server Native Tools, and Microsoft SQL Server 2008 Native Tools are installed on the server performing the remote installation.  The reason for the failure is due to how the installer determines what version of Microsoft SQL Server Native Tools are installed.  We first perform the upgrade/install of the IQRM database.  Prior to the performing the install/upgrade, Aegis looks to determine what version of Microsoft SQL Server Native Tools are installed in the order of Microsoft SQL Server 2005 Native Tools (in add/remove programs this will only be named as Microsoft SQL Server Native Tools) and then, if these native tools are not located, it looks for Microsoft SQL Server 2008 Native Tools.  When the Microsoft SQL Server Native Tools (2005) are found, the installer lands a the SQLCMD.exe file in the following path:

  • C:\Program Files\Microsoft SQL Server\90\Tools\Binn\

When the silent installation for the IQRM database is initiated, it looks for the Microsoft SQL Server Native Tools in the opposite order, beginning with 2008 and then looking for 2005 if Microsoft SQL 2008 Server Native Tools are not found.  It will look in the following path for the SQLCMD.exe file:

  • C:\Program Files\Microsoft SQL Server\100\Tools\Binn\

Since the installer initially found the 2005 native tools, and placed the SQL command file in the C:\Program Files\Microsoft SQL Server\90\Tools\Binn\ path, SQLCMD.exe will not be found and the installer will terminate.

Additional Information

Formerly known as NETIQKB73040