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
Gouache painting of three brass keys on a wooden tray, the first tied with a vermilion ribbon

Free Edition Product Key: Developer, Express and Evaluation

April 14, 2020
Pinal Dave
SQL Tips and Tricks
Developer, SQL Licensing, SQL Server Express, SQL Server Installation, SQL Setup

A free edition product key tells SQL Server setup which free edition to install: Evaluation, Developer or Express. This post lists the three codes, shows how to pass one to an unattended install and how to check the edition afterwards. It also explains when an Evaluation instance ends.

Read More
Gouache painting of a blank cream harbor chart pinned to a wooden board with no marked channels and one vermilion pin

Setup Error 0x86D80018: No More Endpoints Available From the Endpoint Mapper

March 27, 2020
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster, SQL Setup, SQL Upgrade

Setup error 0x86D80018 stopped a SQL Server 2016 to 2017 cluster upgrade when the client patched the second node. The Next Step in the setup summary named an uninstall command. Running it, then rebooting both nodes, let setup finish.

Read More
ssms install error

SQL SERVER – SSMS Install Error 0x80070652 – Setup is Blocked Due to Another Install Currently running. Please Let the Other Install Complete and then Restart the Computer if Necessary

February 14, 2020
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Installation, SQL Server Management Studio, SQL Setup

SSMS install error 0x80070652 says setup is blocked due to another install currently running. Here is what fixed it for me.

Read More
Gouache painting of an old wooden crate with a swollen lid that will not close, bound by a vermilion strap, standing on a stone floor

Setup Error 0x84CF0004: REBUILDDATABASE Permission Update Failed

May 31, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Security, SQL Setup

Setup error 0x84CF0004 appeared when clients rebuilt system databases with SQL Setup. The log said the permission setting update failed for a job history file. Moving the JOBS folder aside and creating an empty one fixed it.

Read More
SQL SERVER - SETUP Error: The Syntax of Argument "/ACTION" is Incorrect

SQL SERVER – SETUP Error: The Syntax of Argument “/ACTION” is Incorrect

December 6, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Setup, Starting SQL

Uninstalling SQL Server from the command line, I got: The syntax of argument “/ACTION” is incorrect. Here is what the error means and how to fix the command.

Read More
SQL SERVER - Install Error: Standalone SQL Server on WFC Cluster Cannot Have Files on Shared Disk Locations

SQL SERVER – Install Error: Standalone SQL Server on WFC Cluster Cannot Have Files on Shared Disk Locations

February 26, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Cluster, SQL Setup

SQL Server 2014 setup failed with an Install Error: standalone SQL Server on a WSFC cluster cannot have files on shared disk. Here is why and what to do.

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
1 2 3 4 Next
  • Books
  • Testimonials
  • Privacy Policy

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