The OLE DB provider “SQLNCLI11” for linked server “…” supplied inconsistent metadata for a column… – How to Resolve

This post explains the error message you might get in SQL Server: The OLE DB provider “SQLNCLI11” for linked server “[…]” supplied inconsistent metadata for a column. The column “[…]” (compile-time ordinal 1) of object “[query…]” was reported to have a Incomplete schema-error logic. You might get the above error message, when you are trying … Read more…

How to Resolve “Property SpaceAvailabable is not available for Database ‘[tempdb]'”

Under certain circumstances, when working in SQL Server Management Studio, you might get the error message “Property SpaceAvailabable is not available for Database ‘[tempdb]’“.   Why I got this message? Most of the times, you might get the above message because something else happened prior to the action that triggered the error message. For example, … Read more…

An error occurred for a dependency of the feature causing the setup process for the feature to fail (SQL Server 2019)

This short tip is about how to handle the following error message, in case you get it when you install SQL Server 2019 RTM: An error occurred for a dependency of the feature causing the setup process for the feature to fail. How to Resolve the Issue There several things you can try for resolving … Read more…

How to Resolve: The description for Event ID 1 from source msodbcsql13 cannot be found.

This is a quick tip, on how to resolve the error message “The description for Event ID 1 from source msodbcsql13 cannot be found.” when trying to start SQL Server Agent. After you ensure that everything is OK with the service account running the SQL Server Agent service, and that the SQL Server service is … Read more…

The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group

So, you have a clustered SQL Server instance (FCI), you try to move (fail over) the entire role to another node of the cluster and you get the below error message: Error Code: 0x80071398 The operation failed because either the specified cluster node is not the owner of the group, or the node is not … Read more…

How to Resolve: Bulk load data conversion error (type mismatch or invalid character for the specified codepage)…

This post helps you how to resolve the BULK INSERT-related error in SQL Server: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row… , column …    Reproducing the issue with an example Consider an example where you have a text file which you want to import in … Read more…

How to Resolve: Cannot Connect to WMI Provider (SQL Server Configuration Manager)

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 Manager. Invalid namespace [0x8004100e]   … Read more…

Error converting varchar to numeric in SQL Server

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 getting this error message and … Read more…

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database

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 error navigate to the report … Read more…

The Maximum Number of Concurrent Connections Setting in SQL Server

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…

A network-related or instance-specific error occurred while establishing a connection to SQL Server

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 correct and that SQL Server … Read more…

SQLServerAgent could not be started (reason: Unable to connect to server ‘(local)’; SQLServerAgent cannot start)

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…

ORDER BY items must appear in the select list if SELECT DISTINCT is specified

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…