Tag Archives: Microsoft SQL Server

Logon failed for login due to trigger execution

microsoft-sql-server

If there is an damaged logon trigger on your Microsoft SQL Server, all login attempts will fail. Cannot connect to servername ADDITIONAL INFORMATION: Logon failed for login ‘DOMAIN\USERNAME’ due to trigger execution. Changed database context to ‘master’. Changed language setting to us_english. (Microsoft SQL Server, Error: 17892) We need to… Read more »

The availability group databases are changing roles from “PRIMARY” to “RESOLVING” during VMWare Snapshot

sqlserver-vmware

After activating Availability Groups, Windows Cluster Failover Service might fail during the snapshot period of VM backup. While Veeam backup is being taken, snapshot holds server and SQL AlwaysOn listener may act like it lost its secondary replica and error messages like below can be received. With the instant effect… Read more »

No available certificates on SQL Server Configuration Manager

SQL Server Security

For activate encrypted connection between Clients and Microsoft SQL Server, configuration must done from Configuration Manager. But, even SSL certificate imported on operating system, list of certificates can be empty. This will be happen, when a non-administrator service account assigned for SQL Server service on operating system. For see certificates… Read more »