SQL Server would not come online after a service pack on a cluster. Here is how ERRORLOG helped me fix this error after cluster patching (error 5184).
![SQL SERVER - Clustered Instance Online Error - SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]](https://blog.sqlauthority.com/wp-content/uploads/2016/11/sql-clus-01.jpg){kind=small}
SQL SERVER – Clustered Instance Online Error – SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]
After a lab restart, the SQL resource stayed Online Pending, then Failed. Here is how the cluster log helped me fix this clustered instance online error.
Special Icon on System-Versioned Table in SQL Server 2016 – Interview Question of the Week #101
Expanding tables in WideWorldImporters in SSMS 2016, you see an icon like a watch. It marks a System-Versioned table, also known as a temporal table.
SQL SERVER – Unable to create login AlwaysOn availability group secondary replica
Creating a login on an AlwaysOn availability group secondary replica failed with Error 3906, database is read-only. Here is why it happens and what to do.
SQL SERVER – Error: 26014 – Unable to Load User-Specified Certificate
A clustered instance would not start: Error 26014, unable to load user-specified certificate. What the ERRORLOG showed and how we got SQL Server running again.
SQL SERVER Management Studio – Taking DB Offline Made Easier
A train ride with my family got me looking at familiar things with fresh eyes, like how SSMS now makes taking a database Offline easier. Here is how.
SQL SERVER – FIX – Error: 26023 – TCP Port is Already in Use
After patching, database mirroring stopped and the ERRORLOG showed Error 26023: TCP Port is already in use on 5022. Here is how we found the cause and fixed it.