Resolve EngageOne Designer SQL Server Service admin rights issues.

Product Feature: Installation / Upgrade

Operating System: Windows

Database: MS SQL

 

Issue

When trying to use EngageOne Designer features such as import/export and backup fail to produce the correct result (either a file or loaded resources into the EngageOne Designer environment)

Cause

The SQL Server Service need admin rights and permission to read/write to the file share where the EngageOne Designer has been set up to store all resources.

Resolution

UPDATED: January 28, 2020
EngageOne Designer has had problems with systems using one of the three Built-in accounts available for the SQL Server Service.  If it is an issue, please have the customer use a "This account" with admin rights.

Here is an explanation of the 3 Built-in accounts.
Local System account:
The Local System option specifies a local system account that does not require a password to connect to SQL Server on the same computer. However, the local system account might restrict the SQL Server installation from interacting with other servers, depending on the privileges granted to the account.

Network Service account:
The Network Service account is a special, built-in account that is similar to an authenticated user account. The Network Service account has the same level of access to resources and objects as members of the Users group. Services that run as the Network Service account access network resources using the credentials of the computer account.
Important:
We recommend that you do not use the Network Service account for the SQL Server. Local User or Domain User accounts are more appropriate for these SQL Server services.

Local Service account:
The Local Service account is a special, built-in account that is similar to an authenticated user account. The Local Service account has the same level of access to resources and objects as members of the Users group. This limited access helps safeguard the system if individual services or processes are compromised. Services that run as the Local Service account access network resources as a null session without credentials.