While deploying SQL Server 2016 cluster in my lab I ran into this problem when I was trying to add a second node to the SQL cluster. Let us learn about Add Node Error and how to solve it in this blog post.
How to Assign Multiple Variables in a Single T-SQL Query? – Interview Question of the Week #148
Question: How to Assign Multiple Variables in a Single T-SQL Query?
SQL SERVER – Startup Error – Your SQL Server Installation is Either Corrupt or Has Been Tampered With
While playing with my virtual machines, I screwed up something and my SQL service for my named instance was failing to start. Let us learn about a startup error.
When I tried to start via services.msc, here was the error
SQL SERVER – Message: “Please wait for the System Event Notification Service” When Trying to Logoff from RDP Session
I must tell you that there could be many reasons for this behavior, but in this blog, I would talk about a cause which was due to SQL Server. Let us learn about how to fix error related to the Notification Service.
SQL SERVER – Msg 7399, Level 16 – The OLE DB Provider “ADsDSOObject” for Linked Server “AD” Reported an Error
One of my blog reader told that they are having trouble with linked server to AD. SQL SERVER – How to Query Active Directory Data Using ADSI / LDAP Linked Server. Let us learn about error related to OLE DB Provider.
SQL SERVER – The Description for Event ID 18456 From Source MSSQLSERVER Cannot be Found
Recently, one of my clients contacted me to understand why they are seeing such messages in their application event log. Where it says The Description for Event ID 18456 From Source MSSQLSERVER Cannot be Found.
SQL SERVER – Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298
Due to development challenge people still use SQL 2012 in production. In one of the case a client told me that their application vendor has not approved SQL 2014 and above, so they were forced to install SQL 2012. There were getting below error while trying to install SQL Server 2012. Let us learn how to fix error while enabling windows feature.