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 key cabinet with most hooks empty and one red tagged key remaining

SQL SERVER – FIX: SQL Service Does Not Start After Promoting the Machine as Domain Controller

December 13, 2017
Pinal Dave
SQL Tips and Tricks
SQL Domain Controller, SQL Error Messages, SQL Server, SQL Server Security, SQL Server Services

A SQL Server machine was promoted to a domain controller and the service stopped starting. Why it broke, the workaround we used, and the real fix.

Read More
Error dialog box.

SQL SERVER – FIX: Msg 15150 – Cannot Alter The User ‘dbo’.

December 12, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Server Security

Deploying SharePoint, a client tried to change the dbo mapping and got Msg 15150: Cannot alter the user ‘dbo’. Here is why it happens and how to fix it.

Read More
Two matching enamel dials side by side in a dark wooden case on a bench

SQL SERVER – AlwaysOn Availability Groups: Script to Sync Logins Between Replicas?

November 30, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Login, SQL Server, SQL Server Security

A script to sync logins between availability group replicas, keeping the SID so users do not orphan on failover. What to copy and what to check after.

Read More
Displaying device and lock icon.

How to Enforce Password Policy of Windows to SQL Server? – Interview Question of the Week #142

October 1, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Login, SQL Scripts, SQL Server, SQL Server Security

SQL Server logins follow Windows password rules by default. If a login has it turned off, here is a simple script to Enforce Password Policy again.

Read More
A gatehouse window with the shutter half down and a red lamp inside

SQL SERVER – Login Failed – Error: 18456, Severity: 14, State: 38 – Reason: Failed to Open the Explicitly Specified Database

September 19, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Server, SQL Server Security

Error 18456 State 38: failed to open the explicitly specified database. The login worked and the database did not. The four usual causes.

Read More
SQL Server Kerberos authentication error.

SCOM – Alert: SQL Server Cannot Authenticate Using Kerberos Because the Service Principal Name (SPN) is Missing, Misplaced, or Duplicated

August 25, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Security

SCOM warned that SQL Server cannot use Kerberos because the Service Principal Name (SPN) is missing. Here is how I checked and fixed the SPNs for a client.

Read More
Node A, Node B.

SQL SERVER – FIX: RequireKerberos Error During SQL 2008 Installation on Windows 2008 R2 Cluster

July 27, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

A client installing SQL Server 2008 on a Windows 2008 R2 cluster hit a RequireKerberos error near the end of setup. Here is the cause and the fix.

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

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