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

Applies to: BizTalk Server Branch 2010BizTalk Server Developer 2010BizTalk Server Enterprise 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