SMTP Adapter issues with BizTalk databses over a SQL Cluster

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

SMTP Adapter issues with BizTalk databses over a SQL Cluster

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> SMTP Adapter issues with BizTalk databses over a SQL Cluster

Page: [1]

Message

<< Older Topic Newer Topic >>

SMTP Adapter issues with BizTalk databses over a SQL Cl... - 13 September 2005

ekta

Posts: 3
Score: 0
Joined: 13 September 2005
Status: offline

Hi,

We are facing peculiar problems with SQL security. We have an orchestration in our solution which picks up emails from the SMTP server. On the development server, the biztalk databases are on the same box, and the orchestration is running fine. Our QA and Production enviroments have the BizTalk databases on a SQL Cluster.

We have added the network and network security accounts in the isolated hosts user group. We have also gone and explicitly added the account in the SQL Server with which the Isolated host logs in. This account is a part of active directory login. We cannot figure out which account needs to be given what rights! Right now, we have almost added every possible user into the SQL Server to experiment. Any directions on this would be greatly appreciated.

When the orchestration is run on QA we get errors (from the event log) in the following order:

Event Type: Information
Event Source: BizTalk Utilities Adapter for SMTP Receiver
Event Category: None
Event ID: 0
Date:  13/09/2005
Time:  15:25:47
User:  N/A
Computer: UKHTNIITBIZ01
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.BizTalk.RegisterIsolatedReceiverEvent
{
String Uri = "smtp://UKHTNIITBIZ01/Receive"
WindowsIdentity Identity = {
     String Name = "NT AUTHORITY\SYSTEM"
     String AuthenticationType = "NTLM"
     Boolean IsAnonymous = False
     Boolean IsAuthenticated = True
     Boolean IsGuest = False
     Boolean IsSystem = True
}
Int32 ProcessID = 2276
String ProcessName = "C:\WINDOWS\system32\inetsrv\inetinfo.exe"
String ThreadName = ""
ComPlusInfo ComPlus = <null>
WindowsSecurityInfo WindowsSecurity = <null>
ManagedSecurityInfo ManagedSecurity = <null>
String StackTrace = ""
String EventSourceInstance = "34674996-b6a2-467c-a47b-b573ea5a4010"
String EventSourceName = "BizTalk Utilities Adapter for SMTP Receiver"
Int64 EventSequenceNumber = 9
String EventSchemaVersion = "2.0.102.0"
DateTime TimeStamp = 13/09/2005 15:25:47
String AppDomainName = "DefaultDomain"
String MachineName = "UKHTNIITBIZ01"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 4
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 6913
Date:  13/09/2005
Time:  15:25:47
User:  N/A
Computer: UKHTNIITBIZ01
Description:
An attempt to connect to "BizTalkMgmtDb" SQL Server database on server "UKHTNIITSQLVS" failed with error: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.".
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5734
Date:  13/09/2005
Time:  15:25:47
User:  N/A
Computer: UKHTNIITBIZ01
Description:
The Messaging Engine failed to register the adapter for "BizTalk Utilities Adapter for SMTP Transport" for the receive location "smtp://UKHTNIITBIZ01/Receive". Please verify that the receive location is valid, and that the isolated adapter runs under an account that has access to the BizTalk databases.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: BizTalk Utilities Adapter for SMTP Receiver
Event Category: None
Event ID: 0
Date:  13/09/2005
Time:  15:25:48
User:  N/A
Computer: UKHTNIITBIZ01
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to Receive an SMTP Message. Details are as follows.
System.Runtime.InteropServices.COMException
The Messaging Engine failed to register the adapter for "BizTalk Utilities Adapter for SMTP Transport" for the receive location "smtp://UKHTNIITBIZ01/Receive". Please verify that the receive location is valid, and that the isolated adapter runs under an account that has access to the BizTalk databases. "
Exception InnerException = {
     String HelpLink = ""
     String Message = ""
     String Source = ""
     String StackTrace = ""
     String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 2276
String ProcessName = "C:\WINDOWS\system32\inetsrv\inetinfo.exe"
String ThreadName = ""
ComPlusInfo ComPlus = {
     String ActivityID = ""
     String ApplicationID = ""
     String TransactionID = ""
     String DirectCaller = ""
     String OriginalCaller = ""
}
WindowsSecurityInfo WindowsSecurity = {
     String CurrentAccountName = "USESIIT\UKHTNIITBIZ01$"
     String ProcessAccountName = "BUILTIN\Administrators"
}
ManagedSecurityInfo ManagedSecurity = {
     String IdentityName = ""
     String AuthenticationType = ""
     Boolean IsAuthenticated = False
}
String StackTrace = " at BTSUtils.Core.Adapters.EnterpriseInstrumentation.Helper.Error(EventSource EventSource, Exception Exception, String Message)
at BTSUtils.Adapters.SMTP.Receive.Receiver.BTSUtils.CDOEX.net.ISMTPOnArrival.OnArrival(IMessage message, CdoEventStatus& eventStatus)"
String EventSourceInstance = "34674996-b6a2-467c-a47b-b573ea5a4010"
String EventSourceName = "BizTalk Utilities Adapter for SMTP Receiver"
Int64 EventSequenceNumber = 10
String EventSchemaVersion = "2.0.102.0"
DateTime TimeStamp = 13/09/2005 15:25:48
String AppDomainName = "DefaultDomain"
String MachineName = "UKHTNIITBIZ01"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 1
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Post #: 1

RE: SMTP Adapter issues with BizTalk databses over a SQ... - 13 September 2005

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

The SMTP Receive Adapter will use the Service Account sopecified within the SMTP Service. This is the Local Network Account.

Since your Sql Server is remote, the remote Sql Server has no knowledge of the SMTP Service Account, and that is why you are receiving the error message about the null user.

What this means is that if you had a local Sql Server running there would be no issues etc.

What makes things even worse is the fact that with the latest Windows 2003 Service Pack, the ability to change the service account for the SMTP Service.

I would recommend that you use the POP3 Adapter. This supports SSL communication as well as NTLM Authentication agains the POP3 Server.

You would not have to change any of your existing configuration except for the Receive Port.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to ekta)

Post #: 2

RE: SMTP Adapter issues with BizTalk databses over a SQ... - 16 September 2005

ekta

Posts: 3
Score: 0
Joined: 13 September 2005
Status: offline

Thanks Pieter. For now we have solved the problem by running the SMTP service under the required login.

We are aware of the issues that may surface, but for now we want to explore all options to keep the SMTP adapter in place.

There is another problem that has us occupied at the moment. How do we use the SMTP adapter under a load shared environment. We have 2 BizTalk Servers and currently I havent been able to configure the adapter to pick up messages from remote SMTP host. I have read the documentation carefully and understand that the adapter works with the local smtp service. Does that mean its not possible to point to a remote smtp server?

Thanks in advance.
Ekta

(in reply to Pieter)

Post #: 3

RE: SMTP Adapter issues with BizTalk databses over a SQ... - 19 September 2005

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

With for instance the MSMQ and MSMQT Protocols a recommended route would be to Network Load Balance the protcols. As far as I am aware the SMTP protocol does not support this type of configuration.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to ekta)

Post #: 4