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.

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: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 : 335