Integrated Security (Windows Authentication)

When Linx Server access MS SQL server with Integrated Security (Windows Authentication), Linx Server makes use of the ‘NT AUTHORITY\SYSTEM’ user to log into MS SQL server. ‘NT AUTHORITY\SYSTEM’ is a built-in Windows Account and it is the most powerful account on a Windows local instance.

In order for the user ‘NT AUTHORITY\SYSTEM’ to log into MS SQL Server, the user needs to have the correct Server Role assigned.
This can be done by assigning the ‘sysadmin’ Role to the user ‘NT AUTHORITY\SYSTEM’ on a server level.

1 Like