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
Summary of Server Status.

SQL SERVER – Unable to Apply Security Patch – The setup has encountered an unexpected error in datastore

January 17, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Security, SQL Setup

A client’s security patch for a SQL 2005 clustered instance failed with Error 29527, unexpected error in datastore. The setup log pointed to the cause.

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
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
Floured hands fold dried fruit into bread dough on a wooden board, with a warm oven waiting behind.

Slipstreaming Updates Into a New Install

October 29, 2008
Pinal Dave
SQL Tips and Tricks
Cumulative Update, SQL Patch, SQL Server, SQL Server Installation, SQL Setup

Slipstreaming Updates lets SQL Server Setup apply a selected CU during installation with UpdateSource and avoids a separate patch pass.

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

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