In SQL Server, there are error few messages which can be caused due to multiple reasons. One of the famous example is “Login Failed for User” error message. If you have seen this earlier, you would know that this message can come due to incorrect user name, incorrect password, incorrect database and many more other reasons. Whenever I see login failed, I look at SQL Server ERRORLOG to see the exact cause.
SQL SERVER – OS Error 13 – The Data is Invalid OS Error 87 – The Parameter is Incorrect – Various Errors due to Faulty Media or Hardware
I offered them quick 15-minute time to see what the errors are and whether I have some techniques to recover the data for invalid OS error 87.
SQL SERVER – Unable to Add Server Name SQLAUTH-LISTENER to Transport Device NetBt_If4 Status 2 – Windows Cluster
During one of my consulting engagement about Always On availability group configuration, I found that listener network name was not coming online. As a rule of thumb, I always generate cluster log for any error related to cluster. SQL SERVER – Steps to Generate Windows Cluster Log?
SQL SERVER – Logon Failure: The User has not Been Granted the Requested Logon Type at This Computer
Sometimes DBA do something which they are not aware of and end up in looking at the logs to see what went wrong. Here is one of the articles I wrote about the changing service account from configuration manager. Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? – Interview Question of the Week #112. In this blog post, let us learn how to fix logon failure error.
SQL SERVER – Slow Installation Wizard on Cluster – Please Wait While Microsoft SQL Server 2016 Setup Process the Current Operation
Have you come across a situation where setup is taking many hours while navigating from one screen to another in clustered environment? Have you ever waited for many hours watching following message related to slow installation wizard on cluster?
SQL SERVER – Script Upgrade Failure – RsFxFt.Dll::RsFxMgmtInitialize failed: Error 0x80070002
In the recent few days, I have found many clients having various script upgrade failures while applying service packs or cumulative updates. Here are few of them. Let us learn about Script Upgrade Failure.
SQL SERVER – Service Pack Error – Attributes do not Match
My virtual machines are my play grounds for any research. A few days ago, on my lab machine, I was having difficulties applying latest service pack. I followed the documentation and looked at the files. In this blog post we will take a look at the service pack error. Here is what I found in Summary.txt