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

Article translations Article translations
Article ID: 2460740 - View products that this article applies to.
Expand all | Collapse all

On This Page

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

Properties

Article ID: 2460740 - Last Review: May 23, 2011 - Revision: 1.0
APPLIES TO
  • Microsoft BizTalk Server Branch 2010
  • Microsoft BizTalk Server Developer 2010
  • Microsoft BizTalk Server Enterprise 2010
  • Microsoft BizTalk Server Standard 2010
Keywords: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew kbbtsadmin KB2460740

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com