Author Archives: Mehmet Yildiz

Remove Server Information, .Net and MVC Information From Response Header

microsoft-iis-logo

In order to prevent information leak findings such as identified server and .NET version in the response of the web server like below, there are some actions to be taken. Especially while hosting an application in Azure as a webapp, owners are unable to configure settings in IIS level and… Read more »

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 »

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 »