Slow SQL Connection or Network in Windows 7

Article ID

ias-10813

Article Name

Created Date

22nd January 2013

Product

Problem

Slow response times in Windows 7 to a SQL Server can be due to the LLMNR protocol. This may be resolved by turning off the LLMNR protocol. LLMNR is a protocol that allows both IPv6/4 computers to perform name resolution for the NetBIOS names of other computers without requiring a DNS server. IPv4 hosts can use NetBIOS over TCP/IP (NetBT) to resolve computer names to IPv4 addresses for neighboring computers by broadcasting a NetBIOS Query. All IPv4-based LLMNR hosts listen on the IPv4 multicast address 224.0.0.252 instruct their Ethernet network adapters to listen for Ethernet frames with a destination multicast address. Windows Vista and 7-based LLMNR computers do not send or respond to unicast queries.

Resolution

To disable LLMNR you will need to Modify the Group Policy on the machine. The following steps describe how to disable LLMNR

Go to Search, Type GPEdit.msc and press Enter

Click Computer Configuration

Double Click Administrative Templates

Double Click Network

Double Click DNS Client

Double Click Turn off Multicast Name Resolution

Click Enabled, Click Apply and Click OK to close.

Share This Page

Thank you for your feedback.

Was this useful?

Yes No

We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.

Escalate to Support?

First Name *

Last Name *

Company Name *

Email Address *

Phone Number *

IRIS Feedback *

For information on how we manage your data please view our privacy policy