eRAMP SSPI Error generated by SQL Server

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 Name=eRAMP;DataSource=[entered via eRAMP db path dialog box]

 

To correct the SSPI error a special version of eRAMP must be created for the eRAMP user.  If you receive the SSPI error contact Cyberlink support to order a version of eRAMP that is compatible with the Security Support Provider Interface. 

 

The special version of eRAMP will change the SQL Server connection string to remove SSPI and add a SQL Server userid and password.

 

To use the special version of eRAMP the user will have to create a SQL Server account in their SQL Server with the following:

 

      login=ERAMP

      password=ERAMP_APP

 

Follow the steps below on your SQL Server to correct the SSPI error and setup your SQL database to work with the special eRAMP update:

 

1. Create new Login ERAMP with the SQL Server authentication option and password ERAMP_APP and default database ERAMP

 

2. Add new user:


      ERAMP with Login ERAMP to the ERAMP database users group with read/write access

 

3. Replace your current eramp.exe with the updated special version of eramp.exe downloaded.

 

If you have any questions please submit a ticket to our support team.


    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...

    • How to script a SQL Database

      To open the Generate and Publish Scripts Wizard In Object Explorer, expand Databases, right-click a database, point to Tasks, and then click Generate Scripts. ... On the Choose Objects page, select the objects to be included in the script. ... On the ...