How to solve “Login failed due to trigger execution”?

How to solve “Login failed due to trigger execution”?

Login failed due to trigger execution
MSSQL Server

Lately, I was trying to run the codemap on my visual studio and got the error “Login failed due to trigger execution”. Details were something like this.

TITLE: Error

Logon failed for login ‘XXXX’ due to trigger execution.

Changed database context to ‘master’.

Changed language setting to us_english. (Microsoft SQL Server, Error: 17892)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=17892&LinkId=20476

Since, I didn’t have much data in the database, I tried deleting the MSSQLLocalDb and recreating using the following sequence of commands in package manager console in my visual studio. I actually got the reference from this stackoverflow link

PM> sqllocaldb info 
MSSQLLocalDB
ProjectModels

PM> sqllocaldb stop MSSQLLocalDB -k
LocalDB instance "MSSQLLocalDB" stopped.

PM> sqllocaldb delete MSSQLLocalDB 
LocalDB instance "MSSQLLocalDB" deleted.

PM> sqllocaldb create MSSQLLocalDB 
LocalDB instance "MSSQLLocalDB" created with version 15.0.4153.1.

This resolved my issues with the codemap. I hope this helps you all.

Leave a Reply

Your email address will not be published.

How to whitelist website on AdBlocker?

How to whitelist website on AdBlocker?

  1. 1 Click on the AdBlock Plus icon on the top right corner of your browser
  2. 2 Click on "Enabled on this site" from the AdBlock Plus option
  3. 3 Refresh the page and start browsing the site
%d bloggers like this: