HomeОбразованиеRelated VideosMore From: SQLGeeksPro

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

13 ratings | 817 views
This video is to show you how to fix the issue when all the logins got disabled
Html code for embedding videos on your blog
Text Comments (6)
Shahrukh Hafeez (3 months ago)
Thanks, You are a Genius. i am able to get in
Kash S (8 months ago)
Thanks
Bobbala Srinivas (11 months ago)
Thanks for the solution.
SQLGeeksPro (11 months ago)
Glad to Help!
amarender Reddydodle (1 year ago)
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.
SQLGeeksPro (1 year ago)
Hi Amarender, DAC is disabled by default in Express edition. You need to Add trace flag "-T7806" to the startup parameters, restart services and then try. If SSMS does not work use command prompt. Also make sure Browser Service is running. You can refer my blog post on DAC to know how to use command prompt for diff authentication. http://sqlgeekspro.com/facts-dedicated-administrator-connection-dac/ Good luck, Dev

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.