The Database Engine system data directory in the registry is not valid

Hi friends, in this article, we will be discussing about the case where you might be updating or patching a SQL Server instance, and under certain circumstances you get the error message: The Database Engine system data directory in the registry is not valid.   The Error Message The exact error message in the above … Read more…

An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint (9642) – How to Resolve

Hi friends, in this article, we will be discussing about how to troubleshoot the following error message: “Event ID: 9642. An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint.“.   About the Service Broker/Database Mirroring transport connection endpoint error We can see from the error message, that it refers to a … Read more…

SQL Server is Terminating Because of Fatal Exception 80000003 – How to Troubleshoot

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…

Resolve SQL Server CTE Error – Incorrect syntax near ‘)’.

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…

How To Manually Remove a Report Server Instance from a Power BI Report Server Scale-Out Deployment Configuration

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…

initerrlog: could not open error log file. Operating system error=3 … – How to Resolve It

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…

Issue Adding Node to a SQL Server Failover Cluster – Greyed Out Service Account – How to Resolve

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…

How to Fix SQL Server Agent Not Showing in a Failover Cluster

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…

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…