If you are trying to add a new node to an existing SQL Server failover cluster and you are getting the error message “There is no SQL Server failover cluster available to join“, then you can perform the below checks: Make sure that all cluster nodes are in the same…
If you are trying to install SQL Server 2016 on Windows Server 2012 R2, under certain circumstances, you might get the below error message: Rule “KB2919355 Installation” failed. Read the article below, in order to get useful suggestions on how you can overcome such issue. The Error Message The below, is…
When you run the SQL Server 2005 setup on a Windows cluster (i.e. installing or uninstalling SQL Server), you might get an error message like the following: Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine. I have experienced this error message…
In case you are trying to install a SQL Server 2008 R2 service pack in a clustered SQL Server environment, under certain circumstances, the installation might fail along with reporting something similar to the below: Final result: The patch installer has failed to update the shared features. To determine the…
When using In-Memory OLTP in SQL Server 2014, under certain conditions you might get the below error message: The transaction log for database ‘[database_name]’ is full due to ‘XTP_CHECKPOINT’ Symptoms One symptom due to the above issue, is that the transaction log of a memory-optimized table, might continue to grow,…
This article discusses how you can resolve the error message: There is insufficient system memory in resource pool ‘internal’ to run this query. Even though you might get the above error message for different occasions, one thing is for sure (after all, the message is quite self-explanatory), it has to…
I have recently experienced an issue which had to do with a third-party application that was trying to retrieve some meta information from a specific SQL Server Instance. It was actually trying to retrieve the names of all the databases contained within that instance. However it was returning the following…
A few days ago I was trying to attach some databases on a SQL Server 2005 instance. The database files were copied over the network and located on a drive on the DBMS server. Though, while I was trying to attach the databases I was getting an error message of…
At some time in the past, I set up a maintenance plan in one SQL Server instance for rapidly tuning up a set of databases with some simple tasks such as index rebuild, etc., and I got the error message: “No global profile is configured. Specify a profile name in…
Well, after a few days of actually doing nothing but sleeping and resting because of the flu, here I am back to blogging! 🙂 A very neat feature of SQL Server is the way it lets the DBA to control connections. To this end, you can explicitly control connections with…
This post’s purpose is to explain the above connectivity error and ways of resolving it. In some cases (upon “wrong” actions or network problems 🙂 we might get the following error in SQL Server: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider,…
Well, as the error message says, whenever we have a division within a SQL query and the denominator has the value of zero (0) we get this error. The exact error we get in SQL Server is: Msg 8134, Level 16, State 1, Line [Here goes the line of the…