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 an old wooden crate with a swollen lid that will not close, bound by a vermilion strap, standing on a stone floor

Setup Error 0x84CF0004: REBUILDDATABASE Permission Update Failed

May 31, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Security, SQL Setup

Setup error 0x84CF0004 appeared when clients rebuilt system databases with SQL Setup. The log said the permission setting update failed for a job history file. Moving the JOBS folder aside and creating an empty one fixed it.

Read More
Gouache painting of an old wooden music box on a table with its crank handle missing, the vermilion crank lying beside it

Setup Error 0x851A0012: REBUILDDATABASE Needs the sa Password

May 25, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Server, SQL Server Security

Setup error 0x851A0012 appeared while I helped a customer rebuild corrupted system databases after a hardware failure. The command had no SAPWD parameter, and the instance used SQL Authentication Mode. Adding SAPWD let setup finish.

Read More
Login vs User

SQL SERVER – Difference Between Login Vs User – Security Concepts

May 21, 2019
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

In this blog post, we discuss the difference between Login Vs User – Security Concepts. They look the same but actually, they are totally different.

Read More
Different chairs surround one table, with a distinct chair at its head

How I Know If I am DBOWNER or Not in SQL Server? – Interview Question of the Week #222

April 28, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Server Security

How do I know if I am DBOWNER or not in SQL Server? A DBA worried about permissions before my changes, so we ran this simple script to check db_owner membership.

Read More
Database Properties - AdventureWorks2012.

SQL SERVER – FIX: Database Diagram Error 15517 – Cannot Execute as the Database Principal Because the Principal ‘dbo’ Does Not Exist

March 4, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Management Studio, SQL Server Security

Opening a database diagram failed with error 15517: Cannot execute as the database principal because the principal ‘dbo’ does not exist. Let me show you the fix.

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
Login Failed Error Dialog In Command Prompt Window.

SQL SERVER – Error: 18456, State 149 – Login-based Server Access Validation Failed With an Infrastructure Error. Login Lacks Connect Endpoint Permission

February 26, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Server, SQL Server Security

Connecting to the DAC with SQLCMD, I got Error 18456, State 149: Login lacks connect endpoint permission. Here is what the ERRORLOG showed and how to fix it.

Read More
Previous 1 … 8 9 10 11 12 13 14 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

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