Monthly Archives: June 2019

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 »

STMS connection error after enable SSL Force on HANA

STMS needs additional configuration for connect HANA database via SSL channel. With default configuration, error will be like: “SQLERRTEXT : only secure connections are allowed” R3Trans does not use parameters from SAP profile files. Need to implement encryption options into sidadm’s global environment variables. For SUSE 12: Edit .profile file… Read more »

VMware VSAN APD Issue – HPE Smart Array Controller Firmware and Driver

Expected VSAN certified driver and firmware for HPE P416ie-m ve P204i-c smart array controller are published. Links are below. You may say ” this is normal situation, any vendor regularly publish a new driver and firmware version”. You are right. But newly published these versions are very important if you… 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 »