iVend Alert Error: VIEW SERVER STATE permission was denied on object 'server', database 'master'.
Environment:
iVend 6.6 with SAP B1
Problem Statement:
iVend Alert Notification displays the error:
CreateSendDumpDataJob : error: VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action. : Site ID 1
Issue Details: iVend Alert Notification displays the error
CreateSendDumpDataJob : error: VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action. : Site ID 1
Symptoms:
Replication Send dump seems to be problematic
Resolution:
We have updated the VIEW SERVER STATE permission was denied on object 'server', database 'master'.
And also started the replication service.
Related Articles
ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"
Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...Cannot open database 'CXSIntegration' login failed
Environment: iVend 6.6 Problem Statement: Cannot open database 'CXSIntegration' login failed Symptoms: Environment Specific Resolution/Work Around: It seems wrong SQL password is entered for user "sa". So need to check correct password for SQL login ...Found error while login MC "Error encountered found in application"
Environment: 6.6.7989 Short Description: Error found in the application Product Query: While login in Management Console found error “Error found in the application” Resolution/Work Around: Not Applicable Recommendations /Suggestion: Ivend Database ...Remove Customer Master which has transaction and also remove those customer which has no transaction
Environment: Ivend 6.6 Problem statement: Need to Remove Customer Master which has transaction and also need to remove those customers which has no transaction details. Resolution/Work Around: 1. Remove customer master which has no transaction ...iVend Alert based issue Error Message : Database 'replicatedmaster' cannot be opened
Environment: iVend 6.6 Problem statement: iVend Alert based issue Error Message : Database 'replicatedmaster' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server error log for more information. This issue may occur for HO or ...