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
A staff locker with its name card slot empty and the door standing slightly ajar.

SQL SERVER – Unable to Start SQL When Service Account is Removed From Local Administrators Group. Why?

July 12, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Server, SQL Server Services

When the service account is removed from local Administrators group, SQL Server may not start. Here is why, and the minimal permissions it needs.

Read More
A mechanical timer with a plain unmarked dial on a dark workshop bench

SQL SERVER – Error: Timeout (30000 milliseconds) Waiting for the SQL Server (MSSQLSERVER) Service to Connect

June 24, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Services, Starting SQL

Timeout 30000 milliseconds waiting for the SQL Server service to connect. Why the service start times out, what to check, and how to give it longer.

Read More
Title card: Error 913: Could Not Find Database ID 3

SQL SERVER – FIX: Error: 913, Severity: 16 – Could Not Find Database ID 3. Database May Not be Activated Yet or May be in Transition – SQL Service

April 10, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Server, SQL Server Services, System Database

SQL Server would not start and the ERRORLOG showed Error 913: could not find database ID 3. Database may not be activated yet. Here is the fix.

Read More
Log icon.

SQL SERVER – Errorlog The Server was Unable to Initialize Encryption Because of a Problem with a Security Library

March 14, 2017
Pinal Dave
SQL Tips and Tricks
Registry, SQL Error Messages, SQL Server, SQL Server Services

SQL Server would not start, and the ERRORLOG said the server was unable to initialize encryption because of a problem with a security library.

Read More
A fitted maintenance cradle supports a mechanism and its lock while a generic spanner rests nearby

Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? – Interview Question of the Week #112

March 5, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Server, SQL Server Configuration, SQL Server Services

Why use SQL Server Configuration Manager Over Services applet (services.msc) to change a service account? The reasons, from permissions to passwords.

Read More
Gouache painting: a long narrow wooden shelf extension built onto a small full pantry cabinet that is too large for the room, one jar with a vermilion lid

Msg 864: Buffer Pool Extension Size Over the Limit

February 28, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Memory, SQL Server Configuration, SQL Server Services

Msg 864 means a buffer pool extension file is larger than SQL Server allows for the memory in the machine. This post gives the limits, four read-only checks tested on SQL Server 2025, and the steps to start a server that will not boot.

Read More
Gouache painting of a shut boat shed door with a padlock and a red key on a hook beside it

Operating System Error 5 on Backup: Fix Access Denied

December 10, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Server Security, SQL Server Services

Operating system error 5 means Windows refused the SQL Server service account access to a backup folder. This post reproduces the error, shows how to find the account with a query, grants the permission, and explains the look-alike errors for missing paths and mapped drives.

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

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