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 a vintage wall toggle switch on a plain slate-blue plate with the lever flipped down and its tip in vermilion

Failed to Create New NBT Interface, Status 1450: Listener Not Coming Online

February 21, 2020
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Computer Network, SQL Error Messages, SQL Server Cluster

Status 1450 showed up in the cluster log when a listener’s IP Address resource would not come online. The error read failed to create new NBT interface. Disabling Enable NetBIOS for this address on the IP resource fixed it.

Read More
Gouache painting of a slate-blue front door, closed, with a brass letter slot sealed by a small vermilion tab

Provisioning Computer Object Failed With Error 5: Always On Listener Failure

January 21, 2020
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Computer Network, SQL Error Messages, SQL Server Cluster, Windows

Provisioning computer object failed with error 5 is a cause of Always On listener creation failure. The cluster log showed the cluster computer object being denied access while changing the listener’s password. Giving the CNO Full Control over the listener object fixes it.

Read More
Gouache painting of two hourglasses of different sizes standing on a wooden desk, with the larger one holding vermilion sand

Connection Timeout Expired: Log Shipping Job Failed to Connect to Server

January 10, 2020
Pinal Dave
SQL Tips and Tricks
Computer Network, Log Shipping, SQL Connection, SQL Error Messages, SQL Server Agent

Connection timeout expired failed a log shipping restore job at a client. The pre-login handshake alone took about 33 seconds, past the 30 second default. Staggering the jobs and adding -logintimeout 60 to the job step fixed it.

Read More
An outdoor lamp remains connected to a remote source through an extension cable

How to Map Network Drive as Fixed Drive? – Interview Question of the Week #258

January 5, 2020
Pinal Dave
SQL Interview Questions and Answers
Computer Network, SQL Command, SQL Scripts, SQL Server, SQL Stored Procedure

Question: How to Map Network Drive as Fixed Drive in SQL Server?
love little problems like this one as they are indeed a lot of fun to resolve. 

Read More
Gouache painting of two wooden cogwheels with different tooth sizes side by side on a workbench so they cannot mesh, one wheel vermilion

Error 17182: Unable to Initialize SSL Support in SQL Server

November 11, 2019
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages, SQL Log, SQL Server Installation, SQL Server Security

Error 17182 says the client and server do not possess a common algorithm. A client could not install SQL Server 2014 because the build did not support TLS 1.2. Switching protocols, patching and switching back fixed it.

Read More
Gouache painting of a worker checking a blocked bridge between two database towers

Network-Related or Instance-Specific Error During SQL Server Installation

April 11, 2019
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Connection, SQL Error Messages, SQL Server Installation

The network-related or instance-specific error is a wrapper message, and during a SQL Server 2014 RTM installation its cause was TLS compatibility. The tests here show how the same message appears for different failures, how to read the number inside it and how to check protocols and encryption.

Read More
Get-AzureStorageBlob: The Remote Server Returned an Error: (403) Forbidden. HTTP Status Code: 403 - HTTP Error Message: This Request is Not Authorized to Perform This Operation

Get-AzureStorageBlob: The Remote Server Returned an Error: (403) Forbidden. HTTP Status Code: 403 – HTTP Error Message: This Request is Not Authorized to Perform This Operation

April 9, 2019
Pinal Dave
SQL Tips and Tricks
Computer Network, PowerShell, SQL Azure, SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts, SQL Server

A runbook cleaning old backup blobs in Azure failed with (403) Forbidden: This request is not authorized to perform this operation. Here is the fix.

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

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