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 2016 setup process.

SQL SERVER – Slow Installation Wizard on Cluster – Please Wait While Microsoft SQL Server 2016 Setup Process the Current Operation

April 13, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster, SQL Setup

Stuck for hours on ‘Please wait while Microsoft SQL Server 2016 Setup process the current operation’? Detail.txt showed the cause of this slow installation.

Read More
SQL SERVER - Error - Attempted to Perform an Unauthorized Operation

SQL SERVER – Error – Attempted to Perform an Unauthorized Operation

October 13, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Setup

A reader’s SQL Server 2016 setup log showed ‘Attempted to perform an unauthorized operation’ during local discovery. Here is what caused it and the fix.

Read More
Gouache painting of a potter's wheel with its tools delivered separately in a box and a red tool roll

Install SSMS: Setup and First Connection

August 8, 2016
Pinal Dave
SQL Tips and Tricks
SQL Server Installation, SQL Server Management Studio, SQL Setup

To install SSMS, download the installer, run it, and connect to your server. This post explains why SSMS is separate from the SQL Server engine, how to fill in the first connection, what to do about the certificate error, and how to check the connection with one query.

Read More
A gate intercom panel on a brick pillar with its faceplate hanging open and no wiring behind it.

SQL SERVER – FIX: Setup Was Not Able to Access Domain

May 2, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Installation, SQL Setup

A DBA installing SQL Server 2012 on a virtual machine got ‘Setup was not able to access domain’. Here is what the message means and how to get past it.

Read More
A hand pulls a clean wooden skewer from the center of a freshly baked cake on a cooling rack.

Checking That a Patch Really Installed

May 18, 2015
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Patch, SQL Server, SQL Setup

Checking That a Patch Really Installed means comparing full versions, reading Setup summary logs, and confirming the startup error log.

Read More
A line of falling wooden dominoes on a floor, with one red domino turned sideways to stop the chain.

Automating SQL Server Patching With PowerShell

November 18, 2012
Pinal Dave
SQL Tips and Tricks
Cumulative Update, PowerShell, SQL Patch, SQL Server, SQL Setup

Automating SQL Server Patching with PowerShell means staging a verified package, running Setup quietly, checking logs, and stopping on failure.

Read More
A pottery kiln working on its own in an empty studio at night

Installing SQL Server Silently From the Command Line

April 25, 2010
Pinal Dave
SQL Tips and Tricks
Command Line, DBA, PowerShell, SQL Server Installation, SQL Setup

Installing SQL Server silently takes a reviewed ConfigurationFile.ini, required setup switches, and a check of logs and active instance settings.

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

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