LogonUserExEx failed in the cluster log, and a listener network name would not come online. The cluster could not log on as the CNO, with error 1326, so DNS registration failed with error 6. Repairing the computer object and restarting the nodes fixed it.
Msg 46530: External Data Sources Are Not Supported With Type GENERIC
Msg 46530 says external data sources are not supported with type GENERIC. The real cause is a PolyBase feature that isn’t installed or isn’t enabled. A SERVERPROPERTY check and one sp_configure call sort it out.
SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?
“I/O is frozen on database” and “I/O was resumed on database”? Did you check the air conditioner temperature? Let us learn about it in today’s blog post.
Msg 17177 in the SQL Server Error Log: What It Means
Msg 17177 is an informational line in the SQL Server error log that reports the process ID of the instance. This post explains its two forms, a daily line and a start-up line, and reads both with a short query. It also shows how the line reveals uptime, downtime and the time zone of the server.
Setup Administrator Rule Failed Even for an Administrator Account
The Setup administrator rule failed for a client even though they were logged on as an administrator. The setup log showed that sqlsccn.dll could not be loaded. The setup media had files missing, and downloading the media again fixed it.
ANSI_WARNINGS OFF: Why SQL Server Truncates Data Silently
With ANSI_WARNINGS OFF, SQL Server cuts a string to fit its column and reports no error. This post runs the same insert with the setting on and off, and shows what else changes: variables, divide by zero and filtered indexes. It also shows how to check which setting a session uses.
Error 15580: Cannot Drop Master Key Because a Dialog Is Encrypted by It
Error 15580 says SQL Server cannot drop the master key because a dialog is encrypted by it. A reader hit it after following my Always On post. Leftover entries in sys.conversation_endpoints were the cause, and a key regeneration cleared them.