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
Maximizing SQL Server Security

Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable

August 10, 2023
Pinal Dave
SQL Tips and Tricks
SQL Instance, SQL Server Security, SQL Server Services

Let us learn more today in this blog about Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable.

Read More
process ID

SQL SERVER – Msg 17177 – This Instance of SQL Server Has Been Using a Process ID of %s since %s (local) %s (UTC)

March 9, 2020
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Error Messages, SQL Log, SQL Server, SQL Server Security, SQL Server Services

In this blog today, I would share my understanding of the message “This instance of SQL Server has been using a process ID of”

Read More
agent missing

SQL SERVER – SQL Server Agent Missing in SQL Server Configuration Manager

January 18, 2020
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Agent, SQL Server Management Studio, SQL Server Services

In this blog, we would look into a special situation where ONLY SQL Server Agent is missing in SQL Server Configuration Manager.

Read More
patch

SQL SERVER – Patch Install Rule Error – Not Clustered or the Cluster Service is Up and Online

August 10, 2019
Pinal Dave
SQL Tips and Tricks
DotNet, SQL Error Messages, SQL Patch, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Services

The error which we observed was a failure of a rule – Patch Install Rule Error – Not clustered or the cluster service is up and online.

Read More
A hermit crab in a fresh shell beside its empty old one, a red starfish nearby.

Running SQL Server Under a Group Managed Service Account

July 23, 2019
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Configuration, SQL Server Security, SQL Server Services

Set up a group managed service account for SQL Server Engine and Agent, then verify permissions, SPNs, and Kerberos connections.

Read More
SQL SERVER - SQL Service Not Getting Started Automatically After Server Reboot While Using gMSA Account

SQL SERVER – SQL Service Not Getting Started Automatically After Server Reboot While Using gMSA Account

February 27, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Agent, SQL Server Security, SQL Server Services

My first gMSA test: SQL Service was not started automatically after server reboot, even with automatic startup set. Here is what the event log showed.

Read More
RSAT-ClusterTools installed in PowerShell.

SQL SERVER – Patch Failure – Unable to Retrieve the Cluster Service

February 1, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Patch, SQL Server, SQL Server Cluster, SQL Server Services

Patching SQL Server 2008 R2 on a Windows Server 2012 cluster failed: unable to retrieve the Cluster Service. Here is what Detail.txt showed and the fix.

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

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