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 a wooden ship's wheel held still by a loop of vermilion rope

Setup Administrator Rule Failed Even for an Administrator Account

March 4, 2020
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server 2019, SQL Server Installation, SQL Server Security

The Setup administrator rule failed for a client even though they were logged on as an administrator. The setup log showed that sqlsccn.dll could not be loaded. The setup media had files missing, and downloading the media again fixed it.

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 two wooden cogwheels with different tooth sizes side by side on a workbench so they cannot mesh, one wheel vermilion

Error 17182: Unable to Initialize SSL Support in SQL Server

November 11, 2019
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages, SQL Log, SQL Server Installation, SQL Server Security

Error 17182 says the client and server do not possess a common algorithm. A client could not install SQL Server 2014 because the build did not support TLS 1.2. Switching protocols, patching and switching back fixed it.

Read More
Gouache painting of a cream wall with a faint pale rectangle where a picture used to hang, and one nail with a vermilion head left in the wall

Setup Error 1060: The Specified Service Does Not Exist During Upgrade

October 22, 2019
Pinal Dave
SQL Tips and Tricks
Reporting Services, SQL Error Messages, SQL Server, SQL Server Installation, SQL Upgrade

Setup error 1060 stopped an in-place upgrade from SQL Server 2008 R2 to 2014 right after the product key. The setup log asked for a ReportServer service that no longer existed. Removing the leftover SSRS fixed it.

Read More
Gouache painting of a stone canal lock with its sluice closed and a small paper boat waiting in the water, a vermilion flag on the boat

Setup Error 25641: Event File Target Parameter Invalid in SQL Server

October 9, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Extended Events, SQL Server, SQL Server Installation, SQL Server Security

Setup error 25641 stopped a SQL Server 2012 installation in a client environment. The ERRORLOG said the filename parameter for the event_file target was invalid. Process Monitor showed Access Denied for the service account on the drive that holds the LOG folder.

Read More
Gouache painting of a half-assembled wooden birdhouse on a workbench, with one vermilion peg in its top and the unused pieces lying beside it

Setup Error 1639: Invalid Command Line Argument in SQL Server

July 30, 2019
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Installation

Setup error 1639 stopped my SQL Server 2019 install with an invalid command line argument message. The real clue was in the log: a component from an earlier incomplete install was still there. Uninstalling it with msiexec fixed the problem.

Read More
Gouache painting of a wooden shelf holding five small ceramic jars, four with blank cream paper tags and one with only a bare vermilion string

ArgumentNullException: Value Cannot Be Null in SQL Server Setup

May 9, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL NULL, SQL Server, SQL Server Installation

Value cannot be null was the message when a client’s automated SQL Server installs failed at random. Detail.txt named the parameter instanceName. The generated configuration file had no InstanceName for a default instance, and that is what setup choked on.

Read More
Previous 1 2 3 4 5 … 12 Next
  • Books
  • Testimonials
  • Privacy Policy

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