Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: "The requested name is valid, but no data of the requested type was found" error when you try to configure BRE to use an instance of SQL Server as a data store in BizTalk Server 2010

FIX: "The requested name is valid, but no data of the requested type was found" error when you try to configure BRE to use an instance of SQL Server as a data store in BizTalk Server 2010

View products that this article applies to.

Symptoms

Consider the following scenario:
  • You install Microsoft BizTalk Server 2010 on a computer.
  • You configure an instance of Microsoft SQL Server to use a nondefault TCP port.

    Note The default TCP port is 1433.
  • You try to configure Business Rule Engine (BRE) to use the instance of SQL Server as a data store.
In this scenario, the configuration fails, and the following error message is logged in the SQL Server log file:
[<date time> Error RulesEngine] System.Net.Sockets.SocketException (0x80004005): The requested name is valid, but no data of the requested type was found
at System.Net.Dns.GetAddrInfo(String name)
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at Microsoft.BizTalk.Configuration.Rules.RulesConfig.ConfigureB2BOperatorsRole(String rulesDbServer, String rulesDbDatabase)
at Microsoft.BizTalk.Configuration.Rules.RulesConfig.ConfigureFeature(String strXMLDoc, String strFullXMLDoc, String& strErrorDescription)

↑ Back to the top

Resolution

Cumulative update information

The hotfix that resolves this issue is included in cumulative update package 1 for BizTalk Server 2010.

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2497789 Cumulative update package 1 for BizTalk Server 2010

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

References

For more information about how to configure BRE by using the BizTalk Server Configuration Manager, visit the following MSDN website:
How to configure BRE by using BizTalk Server Configuration Manager
For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:

2003907 Information about BizTalk Server hotfixes

↑ Back to the top

Keywords: kbqfe, kbfix, kbexpertiseadvanced, kbsurveynew, kbbtsadmin, kb

↑ Back to the top

Article Info
Article ID : 2460740
Revision : 4
Created on : 9/19/2018
Published on : 9/19/2018
Exists online : False
Views : 394