Check our collection of high-quality articles on a variety of SQL Server troubleshooting topics. The collection is being regularly updated with new articles.
In this article, we will be discussing about the File Activation error message in SQL Server and ways to resolve it. The File Activation Error Message in SQL Server In some cases, under certain circumstances, when creating a new database in SQL Server using a T-SQL script that among other, specifies the physical location … Read more…
In this article, we will be discussing about the error message “SQL Server is Terminating Because of Fatal Exception 80000003” and how to troubleshoot it. In more detail, the error message to talk about is: SQL Server is terminating due to fatal exception 80000003. This error can be caused by an unhandled Win32 or C … Read more…
Hi friends, in this post, we will be discussing about how you can resolve the SQL Server CTE Error: Incorrect syntax near ‘)’. What are Common Table Expressions (CTEs)? In SQL Server and more specifically in T-SQL, a CTE is a temporary named result set, from which you can then select records. CTEs are … Read more…
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…