If Microsoft Native client is installed, check whether the version of Microsoft Native client matches the MSSQL version.You can check the MSSQL version executing the query "SELECT SERVERPROPERTY('productversion') as 'Version'" or go to SQL Server Management Studio and right click on the instance name and select the Properties) (Hint: Open command prompt and execute "bcp.exe -v" command in OpManager_Home/bin/ folder to get the version of bcp.exe. Copy the bcp.exe and the bcp.rll files of same version as MSSQL from the binn/ folder in MSSQL installed location and paste it in the OpManager_Home/bin/ folder.When DBConfiguration is completed, start the OpManager service.īCP and MSSQL server version mismatch Solution.Enter the new database name you want to create and press OK. If you wish to create a new database for data storage.
A prompt opens whether you wish to use the same database, press OK. Enter the same database name you want to use in Database Name field and click OK.
Enter the correct authentication User Name and Password.Open command prompt and execute DBConfiguration.bat in OpManager_Home/bin/ folder.Update the correct MSSQL Username and Password in OpManager/NetFlow Analyzer by executing DBConfiguration.bat in OpManager_Home/bin/ folder.Make sure the MSSQL server password does not contain special characters like ‘ ’.(Hint: Open command prompt and execute "bcp.exe -v" command in OpManager_Home/bin/ folder to get the version of bcp.exe.) If there is more than one bcp.exe file, keep the version suitable for MSSQL and delete older versions.Copy the bcp.exe and the bcp.rll files from the binn/ folder in MSSQL installed location and paste it in the OpManager_Home/bin/ folder.
SQLBULK COPY LOG PDF
Download as PDF Troubleshoot BCP errors Error 1īcp.exe or bcp.rll file not found in OpManager_Home/bin folder Solution
0 kommentar(er)
