Home | Knowledge Base Articles | Slow SQL Connection or Network in Windows 7

Thank you for your feedback.

Was this useful?

Yes No

Slow SQL Connection or Network in Windows 7

Article ID

ias-10813

Article Name

Slow SQL Connection or Network in Windows 7

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
    E mail 64 | Slow SQL Connection or Network in Windows 7 twitter | Slow SQL Connection or Network in Windows 7

    • 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.

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

    © IRIS Software Group Ltd 2024