Use an existing SQL Server for your BizTalk environment

Recently i had the ability to use 2 dedicated development machines, one for setting up BizTalk and i figured to use the other for SQL Server.

I sounds easy enough, be it that there are some steps that you should not forget.

Possible error to look for: “Cannot open database BizTalkMgmtDb on server <dummy>.Verify that you have the required security permissions and that communication between Distributed Transaction Coordinator services on the machines involved is not prevented by current DTC security,   firewall or authentication settings.”

Setting up the machines

Preconditions:

o SQL Server is installed

o BizTalk is installed but not configured

Setting up the SQL Server machine

1) Start ‘SQL Server Surface Area Configuration’

o Enable remote connections

(Choose: TCP/IP or TCP/IP and named pipes, disable shared memory)

o Start the SQL Agent

o Start the SQL Browser

2) Start ‘SQL Server Configuration Management’

o Goto ‘Protocols for MSSQL Server’ to enable TCP/IP

· Set Active to ‘Yes’

· Set Enabled to ‘Yes’

· Enable named pipes

3) Configure DTC

a) Start ‘Component Services’

In the control panel, browse to ‘Administrative Tools’\’Component Services’

Right click on properties on the context menu under:

\Component Services\Computers\My Computer\Properties

b) Configure MSDTC

Check the following settings:

· Allow remote connections (remote administration is not required)

· No Authentication required

· Enable XA Transactions

· Enable TIP (not sure is this is required)

for more info see: http://msdn.microsoft.com/en-us/library/aa544733.aspx

Setting up the BizTalk machine

o Manually create the required SSO groups

o For SSO: add user to the SSO Administrators group

o Add authenticated database users to the BizTalk Administrators group

o Repeat steps 3a-b for setting up DTC

Comments

Post a Comment

Popular posts from this blog

Azure implementation guidelines

In My post ‘ Service Bus Management ’ I pointed out a way of implementing a DTAP strategy for managing the Service Bus environment. There’s now a great post available from Microsoft which goes into more detail about other aspects of managing the Azure subscriptions and other artefacts which is quite useful when setting up your Azure environments. Follow this link to the ‘Azure Implementation Guidelines’ HTH, Sander
Read more

Focus and innovation - recap of the last 2 years

It's been a long time since my last post. Hereby a partial explanation for that, with the note that this blog will remain active for the purpose of being a resource for historical references. My IT career started with programming, and adventures within holland, as well as overseas. When I realised programming is something you can specify, I figured that providing added value is crucial for a long term career and decided to focus on process centric roles. I started with webservice integration and eventually from that to process integration using BizTalk. The great feeling when discussing high level processes and implementing solutions within days, even highly scalable and interfacing with LOB systems is great. After several years of implementing solutions like these, I started questioning if all of this work was justified by the business case, if the solution was actually contributing, if the choices had been valid. In other words, I needed to understand the choices made. When...
Read more

BizTalk Pub/sub vs Topics based routing–discussion

My colleagues and I had a brief discussion about the subject ‘Topics’ and what it brings… Do you all agree/disagree with the following statement: topic-based pub-sub messaging doesn’t really exist in BizTalk “In my opinion; I disagree, as BizTalk offers the following 'out-of-the-box' • Message Routing (f.e build in context properties like message type, trading partner, operation etc) • Content Routing (f.e. promoted properties, message inspection in orchestrations/pipelines icw orchestration logic)” My colleague Rene Brauwers Here my 2 cents…. I agree that it exists...however the current offerings in BizTalk are tightly coupled, making the usage far from perfect. When doing content based routing on custom fields (promoted properties), you will be making the solution message-coupled; Your custom message property schema is deployed, and the message filter on these fields have a direct relationship with this property schema. Making any change to this schema will g...
Read more