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

View products that this article applies to.

Expand all | Collapse all

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: "Initial Catalog=BizTalkRuleEngineDb1;Data Source=databaseservername,6069;Integrated Security=SSPI;". ---> 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 "BizTalkRuleEngineDb" on server "BIZTALKSERVER,1433".
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.

Back to the top

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.

Back to the top

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:

Start BizTalk Server Administration.
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.
Right-click the BizTalk Server Host application that you want to determine the Windows group for, and then click Properties.
Click General.

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