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 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
A hand sharpens a plane blade on a whetstone while the empty hand plane waits nearby.

System Configuration Checker WMI Error: Fixing SQL Server Setup

April 12, 2009
Pinal Dave
SQL Tips and Tricks
Bug Fix, SQL Server Installation, SQL Setup, WMI

Setup stopped with a WMI message before installing anything? Here are the safe repair steps, in order, with a quick check at the end.

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

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