locked
Extranet topologies with multiple SQL Servers? RRS feed

  • Question

  • Within my organisation we are planning a project to build a new extranets platform using Sharepoint 2010. Looking at the various topologies recommended for extranet deployment, I am hoping somebody out there can help clear a couple of things up for me.

    My initial plan was to build one Sharepoint 2010 standard farm with two WFE's sitting outside of the corporate network to serve content to extranet users. Internally the farm would have another two WFE's, an application server and the database server. We would deploy our solution internally and then extend the web applications out to the extranet WFE's. However, for security reasons the systems guys do not like the idea of one database server providing data both internally and externally. They would like one database server using Windows authentication for internal data, and one database server using SQL authentication, that both sit within our corporate network.

    So, my questions are.....

    1. Is it possible to use two completely seperate database servers with different authentication types, within one Sharepoint server farm?
    2. If yes, would extending the web applications still work?
    3. Ultimately, if this solution is even possible, is it actually necessary or is one SQL server absolutely fine.

    I appreciate that the questions I have asked could be up for much debate and it is therefore difficult to provide a difinitive answer, but at this stage I am just looking for experienced opinion.

    Thanks in advance for any answers given.

    Tuesday, July 17, 2012 12:05 PM

Answers

  • Hi,

    1. Is it possible to use two completely seperate database servers with different authentication types, within one Sharepoint server farm?
      No, you can not have extended Web application with a separate database because Extending only extend IIS Web Site and not Database Level. 
    2. ...
    3. Ultimately, if this solution is even possible, is it actually necessary or is one SQL server absolutely fine.
      If you keep your SQL Server server in the internal network and implement best practices [like don't use sa user ,..] then it will be fine.


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/


    • Edited by Fadi Abdulwahab Tuesday, July 17, 2012 12:27 PM
    • Proposed as answer by Trevor SewardMVP Tuesday, July 17, 2012 1:27 PM
    • Marked as answer by MarcWP Tuesday, July 17, 2012 2:08 PM
    Tuesday, July 17, 2012 12:27 PM

All replies

  • Hi,

    1. Is it possible to use two completely seperate database servers with different authentication types, within one Sharepoint server farm?
      No, you can not have extended Web application with a separate database because Extending only extend IIS Web Site and not Database Level. 
    2. ...
    3. Ultimately, if this solution is even possible, is it actually necessary or is one SQL server absolutely fine.
      If you keep your SQL Server server in the internal network and implement best practices [like don't use sa user ,..] then it will be fine.


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/


    • Edited by Fadi Abdulwahab Tuesday, July 17, 2012 12:27 PM
    • Proposed as answer by Trevor SewardMVP Tuesday, July 17, 2012 1:27 PM
    • Marked as answer by MarcWP Tuesday, July 17, 2012 2:08 PM
    Tuesday, July 17, 2012 12:27 PM
  • Thanks for your reply. This definitely points me in the right direction


    MWP

    Tuesday, July 17, 2012 2:09 PM