This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
I have the following trigger database trigger 
and then there is a error in the errorlog
why is that ?
Hi @michaelchau,
Is the reply helpful?
If the reply helped, please “Accept Answer” and upvote it to close this case.
Otherwise it will always be open status.
BR,
Mia
yes. I can demo with you if you want.
I would like to see. I again saw message and it has login failed or machinename$ which means its is network service account or local system account of other machine trying to connect to this SQL Server and is failing. Normally to avoid this the account has to be added as login in SQL Server. Can you check if in the domain\machinename$ what is the machine name ?
let me record a video and upload. thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
It is not me that you have to convince. If it indeed is the trigger that causes this error, then do what I said in my earlier post. Open a case with MS. Or, if you can do a repro, then you can report it here: https://feedback.azure.com/forums/908035-sql-server. At least in my opinion a trigger causing that error would be a bug in the product, since I fail to see any reason why this login should happen when a database trigger is fired.
Hi @michaelchau,
but there is no way I need to add this computer account to my sql server. And once the trigger is triggered, the error appear .
yes. I can demo with you if you want.
let me record a video and upload. Thanks.
If the issue always exists after you have tested, please don't hesitate to ask professional engineers for help, and they will deal with your problem separately and confidentially: https://support.microsoft.com/en-us/assistedsupportproducts
BR,
Mia
If the reply is helped, please do “Accept Answer” .