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 worker checking a blocked bridge between two database towers

Network-Related or Instance-Specific Error During SQL Server Installation

April 11, 2019
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Connection, SQL Error Messages, SQL Server Installation

The network-related or instance-specific error is a wrapper message, and during a SQL Server 2014 RTM installation its cause was TLS compatibility. The tests here show how the same message appears for different failures, how to read the number inside it and how to check protocols and encryption.

Read More
A row of piglets crowding a sow in a straw barn to feed, one with a red ear tag nudged out at the end.

Running Several SQL Server Instances on One Machine

February 20, 2019
Pinal Dave
SQL Tips and Tricks
DBA, MAXDOP, SQL Memory, SQL Server Configuration, SQL Server Installation

Budget several SQL Server instances on one Windows host, inventory services, assign memory and ports, and monitor shared resource pressure.

Read More
Caption SQL Keyword Get-Instance.

SQL SERVER – Installation Failure – Specified Instance Via Transform is Already Installed. MSINEWINSTANCE Requires a New Instance that is not Installed

December 31, 2018
Pinal Dave
SQL Tips and Tricks
SQL Documentation, SQL Scripts, SQL Server, SQL Server Installation

A client’s second clustered SQL Server instance failed to install: Specified instance via transform is already installed. Here is what I found and the fix.

Read More
Diagram of SQL Server cluster setup setting the folder permission on the DATA folder under a volume mount point and failing with HResult 0x84cf0003, with the ruled out causes and the real cause, the Audit Object Access policy from a GPO

0x84cf0003: Cluster Install Fails Updating Permission Setting for Folder

December 27, 2018
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Error Messages, SQL Server, SQL Server Cluster, SQL Server Installation

A SQL Server cluster install failed with 0x84cf0003: Updating permission setting for folder failed. Service account rights and folder permissions were fine. The cause was the Audit Object Access policy from a GPO.

Read More
SQL SERVER - Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components

SQL SERVER – Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components

December 7, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Installation, Starting SQL

My SQL Server 2017 install got stuck at Offline Installation of Microsoft Machine Learning Server Components. Here is why it happens and how to move forward.

Read More
Install error: validation for AGTSVCACCOUNT failed.

SQL SERVER – Install Error: Validation for Setting ‘AGTSVCACCOUNT’ Failed. Error Message: The RPC Server is Unavailable

July 21, 2018
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages, SQL Server, SQL Server Installation

A command-line SQL Server install failed: Validation for setting ‘AGTSVCACCOUNT’ failed, the RPC server is unavailable. I read the setup log and found the fix.

Read More
SQL server features.

SQL SERVER – All the Features not Listed While Installing SQL Server

June 2, 2018
Pinal Dave
SQL Tips and Tricks
Business Intelligence, SQL Error Messages, SQL Server, SQL Server Installation

Analysis, Reporting and Integration Services were missing from the Features page while installing SQL Server. The cause was missing MSI files in my setup media.

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

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