Last Updated on
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:
ALL Ephesoft Versions
MSSQL Windows Authentication in connection Manager.
Exception Stack Trace:
188.8.131.52 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’.
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.