In some cases where you might try to launch SQL Server Configuration Manager, you might get the error message: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration…
While developing data processes in SQL Server, under certain circumstances, you might get the error message: error converting varchar to numeric. This error is similar with the conversion error you might get when you are trying to convert a varchar to float, etc. Read on to find out the reason for…
This short blog post helps you troubleshoot the below error message in SQL Server Reporting Services (SSRS): An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help For more information about this…
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…
Under certain circumstances, there are cases where you might try to connect to a SQL Server instance and get the error message: “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is…
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…
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.…
So, you ran a query and got the error message: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. As the above error message explains, you are trying to run a SELECT INTO statement without specifying a column name. Consider the…
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…
Operating System Error 170(Requested Resource is in use) It might happen at some point, under certain circumstances, to get the above error message on your SQL Server environment. Explaining the Error Message The above error means that some other process put a lock on a database file (or other related…
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,…