| Shaheer Abubucker 2004-02-16, 9:36 am |
| Paul,
It is possible to get BizTalk to work when there is a firewall between the
BizTalk server and SQL server.
First, we have to solve the BizTalk Service Account issue. The easiest way
to do this is to have the two domains trust each other and use a domain
account as the service account. If that is not an option, create a local
user on the BizTalk Box and then an identical local user with same password
on the SQL Box - as you have done.
Next, open up the ports in the Firewall in order to allow BizTalk to make
SQL connections. Refer to http://support.microsoft.com/?id=287932
Then, open up Query Analyzer on the BizTalk box and run some simple queries
to make sure that you do have a valid SQL connection.
Finally, open up the ports required for DTC connections between the two
boxes. Refer to http://support.microsoft.com/?id=250367
The article says you should open up a minimum of 15 to 20 ports. BizTalk
makes a LOT of connections to SQL. I'd open up 200 or so ports.
Obviously, you can run tests to see what you need for the amount of volume
you're getting.
Hope that helps,
Shaheer Abubucker
Microsoft Biztalk Server Team
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| Content-Class: urn:content-classes:message
| From: "paul" <anonymous@discussions.microsoft.com>
| Sender: "paul" <anonymous@discussions.microsoft.com>
| Subject: BizTalk messaging service account
| Date: Mon, 16 Feb 2004 13:27:53 -0800
| Lines: 8
| Message-ID: <10d0501c3f4d3$bccf12b0$a301280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcP007zPK9UeZAmuSS6atOVbZvQmDg==
| Newsgroups: microsoft.public.biztalk.server
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.biztalk.server:8989
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.biztalk.server
|
| Is this possible to install BizTalk server outside the
| firewall on a workgroup in the DMZ whereas SQL server is
| behind the firewall on corporate domain? BizTalk
| messaging services will be running on local user account.
| I have tried creating same user account on SQL server
| with same password but because of firewall it doesn't
| work. Is this possible if not how can we implement the
| BizTalk server?
|
|