eRAMP SQL Error SQL Server does not exist or access is denied

eRAMP SQL Error [DBNETLIB][ConnectionOpen(Connect(),]SQL Server does not exist or access is denied

Problem: eRAMP v10 was installed and when the program is opened for the first time an error message displays:

      "[DBNETLIB][ConnectionOpen(Connect(),]SQL Server does not exist or access is denied."

Cause: With eRAMP version 10 a new folder called eramp_data has been created to store eRAMP data files. One of the data files directs eRAMP to open the eRAMP SQL database. In some cases depending on how eRAMP was originally installed the data file with the connection instructions is missing from the new eramp_data folder.


Resolution: To correct this issue start eRAMP. Follow these steps:
  1. Start eRAMP and go to Settings and then Client Settings
  2. At the bottom of the client settings screen re-enter the server name and database path and click apply.
  3. After updating the database path restart eRAMP. You should connect to your SQL database as with the previous version of eRAMP.

    • Related Articles

    • DBNETLIB error

      PROBLEM: After moving eRAMP SQL version to a new workstation upon startup there's an error message DBNETLIB connection failed. eRAMP does not connect to the SQL DB. No loan data is visible in eRamp. CAUSE: The ERAMPDAT.INI file is missing from the ...

    • SSPI Error generated by SQL Server

      The SSPI Error is generated by SQL Server. SSPI is Security Support Provider Interface.   The eRAMP connection string is:       'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=false; Initial Catalog=ERAMP;Application ...

    • File Access Denied or File Transmission is Failed

      Problem: Error message “File Access Denied” displays after clicking Send button from any eRAMP screen. Error message “File Transmission is Failed” when clicking OK from Confirmation>Retrieve Report dialogue box. Cause: User does not have full rights ...

    • Why SQL over Access

      Why SQL over Access: Access utilizes a File Server design while SQL Server employs a Client/Server approach. This is a fundamentally different architecture which has many, many implications. When we refer to Access in this discussion we are really ...

    • SQL Setting up Windows Authentication

      eRAMP SQL users have the option to use Windows Authentication to secure access to their eRAMP SQL database. Follow the instructions below to add Windows Authentication to your eRAMP SQL setup: From the eRAMP Settings>Client Setup Screen there is an ...