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

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

    • Is the API user is configured in ivend configuration manager for retail or for loyalty or for SAP.

      Problem Statement:- Want to change Security user "IvendApp" password from MC. This user is used by ivend for API Authorization . Just wanted to know , is this user is configured in ivend configuration manager for retail or for loyalty or for SAP. ...