Troubleshooting

Error in writing data to the database

Solution:

Verify if the SQL driver is installed and if the bcp.exe and bcp.rll files are present in the <Installation_Directory>\ManageEngine\ADAudit Plus\bin folder.

If the SQL driver is installed but the bcp.exe and bcp.rll files are not present in the product bin folder, follow the steps below.

1. Stop ADAudit Plus
2. Copy the following files from their corresponding locations as shown below:
   • bcp.exe from <MS SQL Installation Directory>\Microsoft SQL Server\Client SDK\ODBC\<version>\Tools\Binn\bcp.exe
   • bcp.rll from <MS SQL Installation Directory>\Microsoft SQL Server\Client SDK\ODBC\ <version>\Tools\Binn\Resources\1033\bcp.rll
3. Paste the files in <Installation_Directory>\ManageEngine\ADAudit Plus\bin folder.

If the SQL driver is not installed, stop ADAudit Plus service and follow the steps below depending on where ADAudit Plus and MS SQL instance are running:

• If ADAudit Plus and the MS SQL instance are running on different computers:

  1. Download and install SQL native client, command line utilities, and ODBC Driver; in the computer on which ADAudit Plus is running.

  SQL Server version	Command Line Utilities (cmdlnutils)	Files to be download for CmdLnUtils	Native Client (ncli)	File to be download for Native client	ODBC Driver (odbc)	File to be downloaded for ODBC Driver
  2008	https://www.microsoft.com/en-in/download/details.aspx?id=44272	SqlCmdLnUtils.msi	https://www.microsoft.com/en-in/download/details.aspx?id=44272	sqlncli.msi	Not Needed	Not Needed
  2012	64 bit: http://go.microsoft.com/fwlink/?LinkID=239650&clcid=0x409 32 bit: http://go.microsoft.com/fwlink/?LinkID=239649&clcid=0x409 Ref: https://www.microsoft.com/en-us/download/details.aspx?id=29065	The previous column contains the download link.	https://www.microsoft.com/en-in/download/details.aspx?id=50402	sqlncli.msi	Not Needed	Not Needed
  2014	https://www.microsoft.com/en-US/download/details.aspx?id=53164	MsSqlCmdLnUtils.msi	Not Needed	Not Needed	https://www.microsoft.com/en-in/download/details.aspx?id=36434	msodbcsql.msi
  2016	https://www.microsoft.com/en-us/download/details.aspx?id=56833	MsSqlCmdLnUtils.msi	Not Needed	Not Needed	https://www.microsoft.com/en-us/download/details.aspx?id=56833	msodbcsql.msi
  2017	https://www.microsoft.com/en-us/download/details.aspx?id=53591	MsSqlCmdLnUtils.msi	Not Needed	Not Needed	https://www.microsoft.com/en-us/download/details.aspx?id=53339	msodbcsql.msi
  2019	64 bit: https://go.microsoft.com/fwlink/?linkid=2230791 32 bit: https://go.microsoft.com/fwlink/?linkid=2231320	MsSqlCmdLnUtils.msi	Not Needed	Not Needed	64 bit: https://go.microsoft.com/fwlink/?linkid=2223304 32 bit: https://go.microsoft.com/fwlink/?linkid=2223303	msodbcsql.msi

  Note: The native client, command line utilities, and ODBC driver version has to be the same as the MS SQL version
  2. Copy the following files from their corresponding locations as shown below:
     • bcp.exe from <MS SQL Installation Directory>\Microsoft SQL Server\Client SDK\ODBC\<version>\Tools\Binn\bcp.exe
     • bcp.rll from <MS SQL Installation Directory>\Microsoft SQL Server\Client SDK\ODBC\ <version>\Tools\Binn\Resources\1033\bcp.rll
  3. Paste the files in <Installation_Directory>\ManageEngine\ADAudit Plus\bin folder.

• If ADAudit Plus and the MS SQL instance are running on the same computer:

  1. Copy the following files from their corresponding locations as shown below:
     • bcp.exe from <MS SQL Installation Directory>\Microsoft SQL Server\Client SDK\ODBC\<version>\Tools\Binn\bcp.exe
     • bcp.rll from <MS SQL Installation Directory>\Microsoft SQL Server\Client SDK\ODBC\ <version>\Tools\Binn\Resources\1033\bcp.rll
  2. Paste the files in <Installation_Directory>\ManageEngine\ADAudit Plus\bin folder.

If the SQL driver is installed and the bcp.exe and bcp.rll are present in the product bin folder and the issue persists, contact support@adauditplus.com