Check our collection of high-quality articles on a variety of SQL Server troubleshooting topics. The collection is being regularly updated with new articles.
Among its plethora of available and useful settings, SQL Server has a setting that is called “Maximum number of concurrent connections“. This setting by default is set to 0 (zero), which means “unlimited” concurrent connections and it is generally advised not to change it. In case you changed this setting there is the risk to … Read more…
In this article, we will be discussing about a popular error message, that is: “A network-related or instance-specific error occurred while establishing a connection to SQL Server” About the network-related or instance-specific error Under certain circumstances, there are cases where you might try to connect to a SQL Server instance and get the error … Read more…
If you are trying to start SQL Server Agent and you get the error message SQLServerAgent could not be started (reason: Unable to connect to server ‘(local)’; SQLServerAgent cannot start) then read below, in order to see what you can try for resolving the issue. How to Resolve the Issue Go to computer management … Read more…
When writing T-SQL code, at some point, under certain circumstances, you might get the error message: ORDER BY items must appear in the select list if SELECT DISTINCT is specified. Explaining the Error Message with an Example But let’s take things from the beginning with the use of an example. First, let’s create a temporary … Read more…
In this article, we will talk about the SQL Server error message “An object or column name is missing or empty” and see how you can easily overcome this error. More about this error message So, you ran a query and got the error message: An object or column name is missing or empty. For … Read more…
Sometimes, under certain circumstances, when you develop in SQL Server and especially when you try to convert a string data type value to a float data type value, you might get the error message: error converting data type varchar to float. As the error message describes, there is a conversion error and this is most … Read more…
This article, discusses how you can resolve the error you might get in SQL Server: Operating System Error 170(Requested Resource is in use) The Root Cause for the Error Message It might happen at some point, under certain circumstances, to get the “Operating System Error 170” error message on your SQL Server environment. The above … Read more…
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 follow the below procedure for resolving the issue. Procedure for Resolving the “There is no SQL Server Failover Cluster … Read more…
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 the exact error message you … Read more…
In this article, we will be discussing about how you can resolve the error message: “Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine“. About the Setup Failure Error When you run the SQL Server 2005 setup on a Windows cluster (i.e. installing or uninstalling … Read more…
In this article, we will be discussing about the following error message: SQL Server 2008 R2 Service Pack Installation Fails – Element not found. (Exception from HRESULT: 0x80070490). About the Above Exception/Error Message In case you are trying to install a SQL Server 2008 R2 service pack in a clustered SQL Server environment, under … Read more…
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, without being able to truncate … Read more…
Question: What I’m I doing wrong and I’m getting the following error message when trying to list my database’s tables? “The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’.” Here’s the screenshot also: Answer: Are you ready for the simplest explanation ever? 🙂 The reason is that -most probably- (hey, you never … Read more…
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 do with memory management. 🙂 … Read more…
OK folks, it did happen at some point, to get this error message: Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. Reproducing the Internal Query Processor Error Message I was trying to execute the following query: SELECT * FROM dbo.tbl1 WHERE tbl2ID=(SELECT … Read more…