Check our collection of high-quality articles on a variety of SQL Server troubleshooting topics. The collection is being regularly updated with new articles.
Hi friends. In this article, we will be discussing about, how you can manually remove a Report Server instance from a Power BI Report Server Scale-out deployment configuration. Why Manually Removing a Report Server Instance from a Power BI Report Server Scale-Out Configuration? There can be many reasons for doing that. However, the most … Read more…
Hi friends, this post, discusses about how you can resolve the following SQL Server-related error message: initerrlog: could not open error log file ”. Operating system error=3 (The system cannot find the path specified). What does the above error message mean? The above error message, as it describes, means that SQL Server cannot find … Read more…
Hi friends! In this post, which is related to SQL Server failover clustering, we will talk about how you can resolve the issue of not being able to add a node to a Server failover cluster, due to the fact that one of the service accounts (i.e. SQL Server or SQL Server Agent, or both) … Read more…
Hi friends, in this post, we will discuss about how you can fix the issue, where SQL Server Agent might not be showing up in a SQL Server Failover Cluster Instance (FCI). SQL Server Agent not showing in Failover Cluster If you have a SQL Server failover cluster, and you cannot see SQL Server Agent … Read more…
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…
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…
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…
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…
This post provides a fix suggestion for the error message “VS Shell Installation has Failed with Exit Code 1638“, when trying to install SQL Server 2016 features on a Windows Server. When you Might Get this Error? You might get the “VS Shell Installation has Failed with Exit Code 1638” error message when trying … Read more…
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…
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…
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…
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…
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…
Sometimes, under certain circumstances, when trying to edit an existing or create a new maintenance plan in SQL Server, using SSMS, just when you try to save the maintenance plan, it might happen to get the error message “No Description Found“. How to Resolve the “No Description Found” Error There is a series of … Read more…
