You are currently offline, waiting for your internet to reconnect

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

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)
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
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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
Properties

Article ID: 2460740 - Last Review: 05/23/2011 02:41:00 - Revision: 1.0

Microsoft BizTalk Server Branch 2010, Microsoft BizTalk Server Developer 2010, Microsoft BizTalk Server Enterprise 2010, Microsoft BizTalk Server Standard 2010

  • kbqfe kbfix kbexpertiseadvanced kbsurveynew kbbtsadmin KB2460740
Feedback
html>