SQL SERVER – Always On Listener Not Coming Online – Failed to Create New NBT Interface, Status 1450

SQL
No Comments

During the recent consulting engagement Comprehensive Database Performance Health Check with my client, one of the DBA was busy with Always On deployment. He asked me if I can help him with some pointers. Since I was able to fix it and learned something, in this blog I would share my learning about fixing error “Failed to create new NBT interface, status 1450 “in cluster log while creating the “IP Address” resource.

SQL SERVER - Always On Listener Not Coming Online - Failed to Create New NBT Interface, Status 1450 NBTinterface-800x461

The situation was that DBA was creating Always On availability group and he was creating listeners also at the same time. After watching the cluster manager while he uses the Wizard and presses the “Finish” button, we found that it was an IP Address resource that was going to a failed state. Hence, I asked to create only an availability group first and then add the listener later.

Once the availability group got created, we tried creating Client Access Point in cluster manager and as expected, IP address resource failed to come online. We generated Cluster logs to find the exact error message. SQL SERVER – Steps to Generate Windows Cluster Log? The relevant portion of the log is pasted below. I have removed some details to make it easy to read.

ERR [RES] IP Address <Cluster IP Address>: Unable to create new NBT interface, status 1450
ERR [RES] IP Address <Cluster IP Address>: Failed to create new NBT interface, status 1450. Deleting stale NBT device from cluster database
INFO [RES] <Unknown Resource>: Successfully deleted NBT interface information from database, status 0.
ERR [RHS] Online for resource Cluster IP Address failed.
WARN [RCM] HandleMonitorReply: ONLINERESOURCE for ‘Cluster IP Address’, gen(96) result 5018/0.
INFO [RCM] Res Cluster IP Address: OnlinePending -> ProcessingFailure( StateUnknown )
INFO [RCM] TransitionToState(Cluster IP Address) OnlinePending–>ProcessingFailure.

WORKAROUND/SOLUTION – NBT Interface

Line # 21 and 2 show the actual error, which is what I mentioned in the blog title. Whenever I see the NBT interface in the error message I always remember NetBIOS over TCP (NetBT). Here is the screen is taken from the internet which shows the setting. This is the properties windows on IP address resource in the cluster.

SQL SERVER - Always On Listener Not Coming Online - Failed to Create New NBT Interface, Status 1450 tcp-netbt-01

To solve this problem, we disabled “Enable NetBIOS for this address” and after that, we were able to bring IP address online and the issue was resolved.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
SQL SERVER – Linked Server Error – Msg 3910 – Transaction Context In Use By Another Session
Next Post
SQL SERVER – Always On Error: This Database is Encrypted by Database Master Key, You Need to Provide Valid Password When Adding it to the Availability Group

Related Posts

Leave a Reply

Menu