Microsoft KB Archive/835862

= SQL Server log on fails when you run a BizTalk Server Orchestration that contains rules =

Article ID: 835862

Article Last Modified on 9/22/2006

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Partner Edition
 * Microsoft BizTalk Server 2004 Standard Edition
 * Microsoft BizTalk Server 2006 Developer Edition
 * Microsoft BizTalk Server 2006 Enterprise Edition
 * Microsoft BizTalk Server 2006 Standard Edition

-





SYMPTOMS
In Microsoft BizTalk Server 2006, you may receive a message in Event Viewer that resembles one of the following:

Event message 1

Event Type: Warning

Event Source: BizTalk Server 2006

Event Category: (1)

Event ID: 5410

Description: The following information is part of the event: An error has occurred that requires the BizTalk service to terminate. The most common causes are an unexpected out of memory error and an inability to connect or a loss of connectivity to one of the BizTalk databases. The service will shutdown and auto-restart in 1 minute. If the problematic database remains unavailable, this cycle will repeat.

Error message: [DBNETLIB][ConnectionWrite (send).]General network error. Check your network documentation.

Error source:

BizTalk host name: ProcessingHost

Windows service name: BTSSvc$ProcessingHost.

Event message 2

Event Type: Warning

Event Source: BizTalk Server 2006

Event Category: (1)

Event ID: 5410

Description: The following information is part of the event: An error has occurred that requires the BizTalk service to terminate. The most common causes are an unexpected out of memory error and an inability to connect or a loss of connectivity to one of the BizTalk databases. The service will shutdown and auto-restart in 1 minute. If the problematic database remains unavailable, this cycle will repeat.

Error message: Error encountered while connecting to database: &quot;Initial Catalog=BizTalkRuleEngineDb1;Data Source=databaseservername,6069;Integrated Security=SSPI;&quot;. ---> Cannot open database requested in login 'BizTalkRuleEngineDb1'. Login fails. Login failed for user 'DATABASE\hostproc1'.

Error source: .Net SqlClient Data Provider

BizTalk host name: ProcessingHost

Windows service name: BTSSvc$ProcessingHost.

Event message 3

Event Type: Error

Event Source: BizTalk Server 2006

Event Category: (1)

Event ID: 6913

Description: The following information is part of the event: sd3-sqlclust9,6069, BizTalkMsgBoxDb1, [DBNETLIB][ConnectionWrite (send).]General network error. Check your network documentation.

Additionally, you may receive an Event ID 5773 in Event Viewer.

In Microsoft BizTalk Server 2004, if you try to run an Orchestration that contains rules, you may receive an error message that is similar to the following:

Uncaught exception terminated service RuleSecDeploy.RuleOrch(315604a6-78fc-24dc-7173-f17aaacd5ffb),

instance 83de0813-2af6-41c4-b178-ae5471da76a3

Cannot open database &quot;BizTalkRuleEngineDb&quot; on server &quot;BIZTALKSERVER,1433&quot;.

Login failed for user 'btsservice'.

Exception type: RuleStoreConnectionException

Source: Microsoft.RuleEngine

Target Site: Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)

Help Link:

Additional error information:

Cannot open database requested in login 'BizTalkRuleEngineDb'. Login fails.

Login failed for user 'btsservice'.

Exception type: SqlException

Source: .Net SqlClient Data Provider

Target Site:

Help Link:

Additional error information:

For more information, see Help and Support Center at http://support.microsoft.com.



CAUSE
This error may occur if you install the BizTalk Server 2006 Runtime or BizTalk Server 2004 Engine before you install the Rules Engine and its associated database. Access permissions to the Rules Engine database for the BizTalk Server Host applications are only granted when the Host applications are created. The Host applications are created when the BizTalk Server 2006 Runtime or BizTalk Server 2004 Engine is installed.

If the Rules Engine database is not installed when the BizTalk Server Host applications are created, the BizTalk Server Host applications are not granted the appropriate permissions to this database.



RESOLUTION
To resolve this problem, add the BizTalk Application Users group to the BTS_HOST_USERS role in the BizTalk Rules Engine database. By default, this database is named BizTalkRuleEngineDb.

If you have created any other BizTalk Server Host applications that are not associated with the BizTalk Application Users group, you must add any groups that are associated with these BizTalk Server Host applications to the BTS_HOST_USERS role in the BizTalk Rules Engine database. To determine the Microsoft Windows group that is associated with a BizTalk Server Host application, follow these steps:
 * 1) Start BizTalk Server Administration.
 * 2) In BizTalk Server 2006, expand BizTalk Server 2006 Administration, expand the group that you want, expand Platform Settings, and then click Hosts. In BizTalk Server 2004, expand Microsoft BizTalk Server 2004, and then expand Hosts.
 * 3) Right-click the BizTalk Server Host application that you want to determine the Windows group for, and then click Properties.
 * 4) Click General.

The Windows group that is associated with this BizTalk Server Host application appears under Windows group.



STATUS
This behavior is by design.

Keywords: kbprb kbbtsrules biztalk2004-2006swept KB835862

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.