Category Archives: MS SQL

Data Import or Update Operations on tables with constraints

If table has constraints, SQL’s data import wizard will throw error while importing data from another table or from test database to prod database. In these cases, it is possible to disable constraints for particular tables. List of constraints can be queried with the script given below. SELECT OBJECT_NAME(constraint_object_id) ‘Constraint… 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 »

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 »