Change another SQL user in iVend Configuration & Services.

Change another SQL user in iVend Configuration & Services.

Environment: 

iVend 6.6


Problem Statement: 

Need to change user on SQL server normally  As we use " sa " user but can we change to another user we create on SQL server.


​Symptoms:

Require to create new SQL user apart from 'Sa'


Resolution/Work Around: 

Need to provide all the permissions to the new user same as per default user "SA" has permission and privileges


Recommendations /Suggestion: 

It is recommended to use iVend Configuration & services using SQL Server id "sa".



    • Related Articles

    • General Settings in SAP Business One

      Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...

    • User permission in SAPB1 for Integrating SAPB1 data

      Environment : iVend 6.6 and SAP HANA Problem Statement : Data updated in the SAP but it not integrating to the iVend. Symptoms : Updated data not showing in the iVend and event is also not showing in the Integration Monitor. Resolution/workaround: ...

    • Removing unnecessary Replication services from iVend

      Product version : 6.6 Problem statement : Removing unnecessary Replication services from iVend Details-In replication connection settings customer has typed the company name and pressed update, now they need to change company name. ( i.e Removing ...

    • compatibility version SAP & SQL Version

      Product Query Customer currently using the SQL version 2016 in HO and stores in 2008 express . SQL 2019 and higher version will support ivend 6.6? SAP Version 10 and Pl 2405 and higher PL version will compatible with ivend integration ? Answer As per ...

    • Price lists integrated with another currency

      Product version : iVend 6.6 Problem Statement: Price lists integrated to iVend with another currency. Base currency is set as local currency in SAP ( e.g. XCD ) , however it is appearing as $ at POS and getting integrated as $ Proposed ...