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
Windows could not start the SQL Server error.

SQL SERVER – SQL Service Not Starting in Cluster- The System Cannot Find the File Specified

February 2, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster, SQL Server Services

A clustered instance would not fail over because the SQL Service on Node2 did not start: the system cannot find the file specified. Here is what we found.

Read More
Gouache painting of a small wooden footbridge over a quiet stream, with one plank missing in the middle and a vermilion rope tied across the gap

Cluster Remote Access Rule Failed During SQL Server Cluster Setup

January 16, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server Cluster, SQL Server Installation, SQL Setup

The Cluster Remote Access rule failed while I installed a SQL Server failover clustered instance. Detail.txt showed setup could not reach a remote node. I checked the usual causes, then skipped the rule from the command line, and the install finished.

Read More
SQL server error dialog.

SQL SERVER – The Cluster Resource ‘SQL Server’ Could Not be Brought Online Due to an Error Bringing the Dependency Resource

September 18, 2017
Pinal Dave
SQL Tips and Tricks
SQL Domain Controller, SQL Error Messages, SQL Server, SQL Server Cluster

Installing a second SQL Server 2012 instance on my Windows cluster failed: the cluster resource ‘SQL Server’ could not be brought online. Here is the fix.

Read More
Intact cases remain in an existing frame beside a prepared target frame and a separate staging bench.

SQL SERVER – Changing Cluster Domains with WSFC and SQL FCI Support Limits

September 16, 2017
Pinal Dave
SQL Tips and Tricks
SQL Domain Controller, SQL Server, SQL Server Cluster

To Move SQL Server Cluster installations between domains, I plan an application-specific migration. The Windows cluster capability alone does not establish SQL support.

Read More
SQL SERVER - Unable to Get Listener Properties Using PowerShell - An Error Occurred Opening Resource

SQL SERVER – Unable to Get Listener Properties Using PowerShell – An Error Occurred Opening Resource

September 9, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, PowerShell, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Cluster

A client could not change listener properties with PowerShell and got “An error occurred opening resource”. Here is the T-SQL query I shared and what fixed it.

Read More
A steel patch plate bolted over a pipe, its new bolts painted red

SQL SERVER – Cluster Patching: The RPC Server is Too Busy to Complete This Operation

August 18, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster

A cluster patch failed with The RPC server is too busy. The real cause was a stopped Remote Registry service on the other node, and why it was off.

Read More
SQL SERVER - Installation Error - Status Code: 183 Description: Cannot Create a File When that File Already Exists

SQL SERVER – Installation Error – Status Code: 183 Description: Cannot Create a File When that File Already Exists

June 9, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster, SQL Server Installation

SQL Server 2014 setup on a Windows 2012 cluster with mount points failed with Status Code 183: Cannot create a file when that file already exists.

Read More
Previous 1 … 4 5 6 7 8 9 10 11 Next
  • Books
  • Testimonials
  • Privacy Policy

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