locked
Multiple BizTalk server on single instance of Sql server RRS feed

  • Question

  • Hi,

    For development env setup, can we have only one Sql server instance and configure multiple biztalk server on it?

    If yes then how to achive this?

    Thanks for your support in advance.


    -- Sagar Sharma


    • Edited by Sagar Sharma Monday, September 3, 2012 10:41 AM spelling mistakes
    Monday, September 3, 2012 10:37 AM

Answers

  • I would suggest , have a standalone VM for each developer. IMO that is the better option. Having multiple instances on same SQL might make it slow in future.


    HTH,
    Naushad Alam

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
    alamnaushad.wordpress.com
    My TechNet Wiki "BizTalk Server: Performance Tuning & Optimization"

    • Marked as answer by Sagar Sharma Monday, September 3, 2012 12:35 PM
    Monday, September 3, 2012 11:05 AM
    Moderator
  • The BizTalk developer edition is for free and the SQL Server developer edition is almost free ($50).

    I'd go for single server installs for your development environment if your only argument would be saving licensing costs.

    Using BizTalk is a strategic choice so BizTalk development will probably around in your company for the coming years. It would be wise to start right with your development environment.


    Jean-Paul Smit | Didago IT Consultancy
    Blog | Twitter | LinkedIn
    MCTS BizTalk 2006/2010 + Certified SOA Architect

    Please indicate "Mark as Answer" if this post has answered the question.



    • Edited by Jean-Paul Smit Monday, September 3, 2012 11:29 AM
    • Proposed as answer by Rajasekhar.R Monday, September 3, 2012 12:19 PM
    • Marked as answer by Sagar Sharma Monday, September 3, 2012 12:35 PM
    Monday, September 3, 2012 11:27 AM
  • There is no limit regarding the number of applications in the developer edition. It is in fact an enterprise edition that you can use for test/development.

    http://www.microsoft.com/biztalk/en/us/editions.aspx


    Jean-Paul Smit | Didago IT Consultancy
    Blog | Twitter | LinkedIn
    MCTS BizTalk 2006/2010 + Certified SOA Architect

    Please indicate "Mark as Answer" if this post has answered the question.

    • Marked as answer by Sagar Sharma Tuesday, September 4, 2012 9:20 AM
    Monday, September 3, 2012 12:52 PM

All replies

  • yes you can have multiple biztalk database on same server ... but u cant have multiple SSO database on same server..

    Hence u can join the same SSO ..

    ANd for  Biztalk database change the database for second instaltion..

    Monday, September 3, 2012 10:44 AM
  • If you need to have multiple BizTalk development environments, then I'd go for multiple single server installations.

    This means installing both SQL Server and BizTalk Server on one machine, so you can stick to a default install. Developers have their own environment (virtual or not) and don't have to worry about interference from other developers.


    Jean-Paul Smit | Didago IT Consultancy
    Blog | Twitter | LinkedIn
    MCTS BizTalk 2006/2010 + Certified SOA Architect

    Please indicate "Mark as Answer" if this post has answered the question.

    Monday, September 3, 2012 10:45 AM
  • Hi Sagar,

           You need to be bit more clear on what is the purpose of having Multiple BizTalk servers. You can have multiple BizTalk servers pointing to same SQL instance . This configuration is mostly used for Load Sharing (scale-out) or failover scenario in Production. I am not sure that is your purpose in development environment.

    Regards,

    Vijendra


    • Edited by VijenS Monday, September 3, 2012 10:52 AM
    Monday, September 3, 2012 10:52 AM
  • Thanks Nadeem for your prompt response. Having joined SSO will be ok? as on each BizTalk server we will be configuring with different user accounts (developers).


    Thanks and Regards, Sagar.

    Monday, September 3, 2012 10:53 AM
  • Hi Jean-Paul, Thanks for your response. Yes what you have mentioned is definately a better option. But as of now we are studing all possible senarios. So just trying with "Multiple BizTalk server on single instance of Sql server" option.

    Thanks and Regards, Sagar.

    Monday, September 3, 2012 10:55 AM
  • Hi Vijendra, I am looking for this option as a development env setup. And exloring with the options on "How can we reduce the software and hardware cost in setting up development env"

    Thanks and Regards, Sagar.

    Monday, September 3, 2012 10:58 AM
  • I would suggest , have a standalone VM for each developer. IMO that is the better option. Having multiple instances on same SQL might make it slow in future.


    HTH,
    Naushad Alam

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
    alamnaushad.wordpress.com
    My TechNet Wiki "BizTalk Server: Performance Tuning & Optimization"

    • Marked as answer by Sagar Sharma Monday, September 3, 2012 12:35 PM
    Monday, September 3, 2012 11:05 AM
    Moderator
  • The BizTalk developer edition is for free and the SQL Server developer edition is almost free ($50).

    I'd go for single server installs for your development environment if your only argument would be saving licensing costs.

    Using BizTalk is a strategic choice so BizTalk development will probably around in your company for the coming years. It would be wise to start right with your development environment.


    Jean-Paul Smit | Didago IT Consultancy
    Blog | Twitter | LinkedIn
    MCTS BizTalk 2006/2010 + Certified SOA Architect

    Please indicate "Mark as Answer" if this post has answered the question.



    • Edited by Jean-Paul Smit Monday, September 3, 2012 11:29 AM
    • Proposed as answer by Rajasekhar.R Monday, September 3, 2012 12:19 PM
    • Marked as answer by Sagar Sharma Monday, September 3, 2012 12:35 PM
    Monday, September 3, 2012 11:27 AM
  • Thanks Jean-Paul,

    One more thing, as I get to know from Microsoft BizTalk licencing portal that only one application is allowed on BizTalk Server Dev edition. Is it true? Any work-around for this?


    Thanks and Regards, Sagar.

    Monday, September 3, 2012 12:36 PM
  • There is no limit regarding the number of applications in the developer edition. It is in fact an enterprise edition that you can use for test/development.

    http://www.microsoft.com/biztalk/en/us/editions.aspx


    Jean-Paul Smit | Didago IT Consultancy
    Blog | Twitter | LinkedIn
    MCTS BizTalk 2006/2010 + Certified SOA Architect

    Please indicate "Mark as Answer" if this post has answered the question.

    • Marked as answer by Sagar Sharma Tuesday, September 4, 2012 9:20 AM
    Monday, September 3, 2012 12:52 PM
  • Dear Nadeem,

    Are you sure about this information?

    We have SSODB's of different Biztalk Servers on the same SQLServer instance

    Could you double check please?

    Best Regards

    Wednesday, June 8, 2016 11:15 AM
  • Welcome to MSDN.  This thread is very old.  If you have a specific question, please start a new thread.
    Wednesday, June 8, 2016 1:26 PM
    Moderator