SQL Server replication requires the actual server name to make a connection to the server – How to Resolve it

When working with SQL Server replication and you try to add a new subscription under a local publication, under certain circumstances you might end up with the error message: Cannot connect to … SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name (Replication.Utilities).   … Read more…

The OLE DB provider “Microsoft.ACE.OLEDB.12.0” has not been registered – How to Resolve it

In this article, we will be discussing about the error message [The OLE DB provider “Microsoft.ACE.OLEDB.12.0” has not been registered] and how you can easily resolve it.   Importing Data from Excel to SQL Server via SSMS In most of the cases, you might get the [OLE DB Provider “Microsoft.ACE.OLEDB.12.0” has not been registered] error … Read more…

[Resolved] Operand type clash: int is incompatible with uniqueidentifier

When developing in SQL Server, under certain circumstances, you might get the error message: Operand type clash: int is incompatible with uniqueidentifier. In this article, we will be discussing about, why you got that message, what’s wrong in your T-SQL script and how to fix it.     About the above “Operand type clash: error … Read more…

How to Resolve: The feature “Scale-out deployment” is not supported in this edition of Reporting Services

Under certain circumstances, when upgrading SQL Server Reporting Services Standard Edition, for example from SSRS 2012 or 2014 to SSRS 2017 or 2019, you might get the following error message when trying to start the Reporting Services service: “The feature “Scale-out deployment” is not supported in this edition of Reporting Services“. But first, let’s discuss … Read more…

The feature you are trying to use is on a network resource that is unavailable

Under certain circumstances, it might happen when trying to add a feature to an existing SQL Server installation (i.e. adding SQL Server Integration Services), to get the following error message: “The feature you are trying to use is on a network resource that is unavailable“. The above error message, might be referring to Microsoft SQL … Read more…

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…