This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - Slow SQL Server 2016 Installation in Cluster: RunRemoteDiscoveryAction

SQL SERVER – Slow SQL Server 2016 Installation in Cluster: RunRemoteDiscoveryAction

May 30, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Registry, SQL Error Messages, SQL High Availability, SQL Server, SQL Server Cluster

A client’s SQL Server 2016 Installation in Cluster hung at RunRemoteDiscoveryAction while setup ran discovery on the other node. Here is the cause of the delay.

Read More
Sql server configuration manager.

SQL SERVER – Unable to Failover SQL Server Instance – Error: Registry Information is Corrupt or Missing

May 28, 2018
Pinal Dave
SQL Tips and Tricks
Registry, SQL Error Messages, SQL Log, SQL Server, SQL Server Cluster

A client could not failover SQL Server to another node: registry information is corrupt or missing. Here is how I found the right error in the logs.

Read More
Setup Support Rules error screen.

SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 2

May 26, 2018
Pinal Dave
SQL Tips and Tricks
SQL Domain Controller, SQL Error Messages, SQL Server, SQL Server Cluster, Windows

Part 2 of my series on the MSCS cluster verification errors rule in SQL Server setup: another cause we found in Detail.txt during install or AddNode.

Read More
Setup Support Rules dialog showing Microsoft Cluster Service failure.

SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 1

May 25, 2018
Pinal Dave
SQL Tips and Tricks
SQL Domain Controller, SQL Error Messages, SQL Server, SQL Server Cluster, Windows

Installing a SQL Server clustered instance failed the Microsoft Cluster Service (MSCS) Cluster Verification rule. Part 1 covers the verification report cause.

Read More
SQL SERVER - Unable to Bring SQL Cluster Online - Reason: The Account is Disabled

SQL SERVER – Unable to Bring SQL Cluster Online – Reason: The Account is Disabled

May 21, 2018
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Server, SQL Server Cluster, SQL Server Management Studio, SQL Server Security

After security hardening, a client’s SQL cluster resource sat in Online Pending, then failed: the account is disabled. Here is how we found and fixed it.

Read More
Model dialog in sql server 2016 login properties.

SQL SERVER – SQL Server Cluster Resource Doesn’t Come Online Randomly

May 19, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster, SQL System Table, SQL Trace, System Database

A client’s SQL Server Cluster Resource sometimes failed to come online after a failover to another node. Here is what caused it and how we fixed it.

Read More
SQL Server Configuration Manager.

SQL SERVER – SharePoint not Working After Failover to Another Node

April 23, 2018
Pinal Dave
SQL Tips and Tricks
SharePoint, SQL Error Messages, SQL High Availability, SQL Scripts, SQL Server, SQL Server Cluster

After a SQL Server cluster failover, SharePoint users could not open any page, though all SQL resources were online. Here is what we found and how we fixed it.

Read More
Previous 1 2 3 4 5 6 7 … 11 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com