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
Title card: No More Endpoints Available From the Endpoint Mapper

SQL SERVER – Upgrade Failure – There are No More Endpoints Available From the Endpoint Mapper

March 27, 2020
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Command, SQL Error Messages, SQL Server, SQL Setup, SQL Upgrade, Starting SQL

When my client was trying to patch the other node, it failed with an error – There are No More Endpoints Available From The Endpoint Mapper

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
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
SQL Server management studio dialog.

SQL SERVER – Error – Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group

November 21, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL High Availability, SQL Scripts, SQL Server, SQL Setup

The AlwaysOn wizard said auto close is enabled, so the database can’t join an availability group. Here is why, and the settings to change first.

Read More
A row of numbered pigeonholes on a post office wall beginning at one, with an empty bracket where a lower number would have been.

SQL SERVER – Service Pack Error – Index (Zero Based) Must be Greater Than or Equal to Zero and Less Than the Size of the Argument List

April 21, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Installation, SQL Service Pack, SQL Setup

A service pack failed with: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Here is what I found.

Read More
1 2 3 Next
  • Books
  • Testimonials
  • Privacy Policy

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