How to fix `Logon failed for login 'username' due to trigger execution` error with mssql
I recently tumbled upon an error when trying to connect to SQL Server in nodejs using
Logon failed for login 'username' due to trigger execution
I have no problem connecting to a dev db server of mine, probably due to I don’t have any restriction/security setup on it. I only got this when connecting to a production server.
Problem lies in the default driver
tedious used by
mssql. Changing to
tds fixes the problem.
I don’t actually understand the problem behind this so if anyone knows, please help explain it to me.