All SQL Logins got disabled due to a trigger (Logon failed due to trigger execution)

preview_player
Показать описание
This video is to show you how to fix the issue when all the logins got disabled
Рекомендации по теме
Комментарии
Автор

Hi, I'm using SQL SERVER 2014 EXPRESS edition, this is not working for me. it is again showing the error that
TITLE: Connect to Database Engine


Cannot connect to admin:AA-PC\SQLEXPRESS.


ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 43 - An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number) (Microsoft SQL Server, Error: -1)

Could you please let me know how to solve this issue.

amarenderreddydodle
Автор

Thanks Gods. Jazaq Allah. May u live long.

codingislife
Автор

super boss.. it worked well, thank you so much

KeerthiReddy-jvju
Автор

Bro this query engine is not opened for me. I'm getting error 43

prasathm
Автор

Thank you very much...it worked perfectly....!!!

AmolLahane
Автор

Thanks, You are a Genius. i am able to get in

shahrukhhafeez