Error: Unable to connect: SQL Server is unavailable or does not exist

  • KM02601773
  • 24-Oct-2016
  • 24-Oct-2016

Summary

Customer gest the following error when trying to replay a MS SQL script in LoadRunner 11 Error: DB-Library error msg (Number=10004, Severity=9, Function=dbopen): Error: Unable to connect: SQL Server is unavailable or does not exist. Specified SQL server not found.

Error

Customer gest the following error when trying to replay a MS SQL script in LoadRunner 11

Error: DB-Library error msg (Number=10004, Severity=9, Function=dbopen):
Error:     Unable to connect: SQL Server is unavailable or does not exist.  Specified SQL server not found.
Error:     OS msg number=53:
Error:     ConnectionOpen (CreateFile()).
lrd_open_cursor: ERROR, return-code=LRDE2009

Cause

The error is caused by incompatibility between the  MS SQL Client Tools used by the application and the ones that are used by VuGen.

To fix the issue:

  1. Backup the file ntwdblib.dll in the bin folder of the LoadRunner's installation
  2. Go to the AUT application installation folder
  3. Copy the file ntwdblib.dll and paste it in LoadRunner's bin folder
  4. Try replaying the script again.