Syncronize Site Databases via the Environment Manager Console

Version 1

    Verified Product Versions

    AppSense Environment Manager 8.6AppSense Environment Manager 8.5AppSense Environment Manager 8.4AppSense Environment Manager 8.3AppSense Environment Manager 8.2AppSense Environment Manager 8.1AppSense Environment Manager 8.0

    Introduction

    When attempting to replicate user data via Tools > Synchronize Site Databases option in the Environment Manager console you see the error below:

    UserName [AppSense\Service]
    The EXECUTE  permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.

    Detail

    Synchronize Site Databases causes replication of the user data to occur immediately; normally it is replicated at midnight.  The setup procedure intentionally does not set this up because of the possible security implications.  The login used by the Personalization Server is set up by the Server Configuration Utility at time of installation. 

    For Synchronize Site Databases to work your AppSense service account must be added to the SQLAgentOperatorRole in the msdb database. This needs to be initiated on the publisher database.  This solution can also be found in the paragraph entitled 'Post Setup Steps' of the 'Personalization Database Replication' section of the AppSense Environment Manager Installation and Upgrade Guide.