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.
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.