KB00021791: Issue in configuring MSSQL Windows Authentication when connecting to Remote MSSQL

Issue Description:

In case you are trying to configure MSSQL Windows Authentication Issue through web UI in connection Manager and you are connecting to remote MSSQL instance then there may be a possibility that you see below exception message either for some windows users or for some other username with which your Ephesoft service is running:


Applies to:

ALL Ephesoft Versions



MSSQL Windows Authentication in connection Manager.


Exception Stack Trace: Windows 10 2018-04-11T07:02:29,598 ERROR http-nio-8080-exec-9 com.ephesoft.gxt.systemconfig.server.SystemConfigServiceImpl – Unable to make connectionLogin failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.
java.sql.SQLException: Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.


Root Cause:
User with which your Ephesoft Service is running does not exist or the user lacks access rights.If you are using Local System account then you will need to map Ephesoft service to a valid service account first.



Create a user at Database side and grant him CONNECT access rights or admin access for connection to successfully work.