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
Variables for validating passwords.

MySQL – Fix – Error – Your Password does not Satisfy the Current Policy Requirements

June 27, 2017
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Password, SQL Server Security

MySQL rejected every password with “does not satisfy the current policy requirements”. Here is how to check the validate_password settings and fix it.

Read More
Gouache painting of a round wooden jar with a vermilion rim and a lid resting beside it that is a little too small to fit

Msg 3168: Backup Made by a Different SQL Server Version

June 23, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Server, SQL Server Security, System Database

Msg 3168 stopped a client from restoring master after a ransomware attack, because the backup and the new server had different build numbers. The fix is to make the two builds match, by patching up or uninstalling patches, and then restore again.

Read More
Change job owner.

SQL SERVER – FIX: Msg 15170, Level 16, This login is the Owner of 1 Job(s). You Must Delete or Reassign these Jobs Before the Login can be Dropped

June 21, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Server Security

Msg 15170: this login is the owner of 1 job(s) and cannot be dropped. Here is how to find those jobs and reassign them first.

Read More
keycertificates

Domain Controller – Startup Issue – Unable to Use Domain Account as Service Account When Read Only Domain Controller (RODC) is Involved

June 16, 2017
Pinal Dave
SQL Tips and Tricks
SQL Domain Controller, SQL Error Messages, SQL Server, SQL Server Encryption, SQL Server Security

SQL Server would not start under a domain account when a Read Only Domain Controller (RODC) was involved. Here is what fixed it.

Read More
SQL SERVER - How to Enable Lock Pages in Memory?

SQL SERVER – How to Enable Lock Pages in Memory?

June 15, 2017
Pinal Dave
SQL Performance
SQL Memory, SQL Server, SQL Server Security, Starting SQL

Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it.

Read More
Run as administrator.

SQL SERVER – Msg 15137, Level 16 – Error Related to sp_xp_cmdshell_proxy_account

June 14, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Server Security

A client using a proxy account to run xp_cmdshell hit Msg 15137 with sp_xp_cmdshell_proxy_account. Here is what causes the error and how I fixed it.

Read More
SQL SERVER - xp_logininfo - Msg 15404: Could not obtain information about Windows NT group/user, error code 0x2147

SQL SERVER – xp_logininfo – Msg 15404: Could not obtain information about Windows NT group/user, error code 0x2147

May 29, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Server, SQL Server Security

xp_logininfo failed with Msg 15404 for some users, yet worked for the same user in another domain. Here is what to check to find the difference.

Read More
Previous 1 … 16 17 18 19 20 21 22 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

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