locked
Can I have a 2 computer server farm? RRS feed

  • Question

  • Hello Community

        I have heard suggestions not to put Sharepoint on a domain controller.

        I have 2 servers and one of them is a domain controller the other is not.

        I am implementing a farm so I have no other choice but to put Sharepoint
    on the domain controller and on the other server in order to have a farm.
       
        At a minimum I will have SQL Server, Active Directory, ASP.Net web applications
    DNS and VPN running on this farm.

        What is the best way to configure the server farm knowing that I only have
    one domain controller and one member server to install Sharepoint on?

        Thank you
        Shabeaut



    • Edited by Shabeaut Thursday, September 29, 2011 12:04 AM
    Thursday, September 29, 2011 12:03 AM

Answers

  • Hello Shabeaut,

    Again referring back to the same article, if you want to configure SharePoint in farm mode, SQL and SharePoint needs to be on different servers which in the above post doesnt look like.
    Please take time to read the above article and please let me know if you have any questions.


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Regards,
    Nishant Shah
    Microsoft Online Community Support
    • Marked as answer by Shabeaut Tuesday, October 11, 2011 2:41 AM
    Monday, October 10, 2011 9:35 AM
    Moderator

All replies

  • Hello Community

        Taking everything into consideration there are only 2 servers on the network
    my Sharepoint Server farm exists on one domain controller and one member server.

        Some things should not go on the domain controller so I configured the farm as follows:

    Domain Controller:

        SQL Server
        Exchange Server
        VPN
        DNS

    Member Server:

        WFE
        Applicaton Server
        IIS
        EXCEL
        ADOBE

    I think "Windows Sharepoint Services Web Application" is also
    called WFE (Front end Server).

        Thank you
        Shabeaut



    • Edited by Shabeaut Thursday, October 6, 2011 9:02 PM
    • Merged by Qiao WeiModerator Tuesday, October 11, 2011 10:44 AM similar issue
    Wednesday, October 5, 2011 9:06 PM
  • Hello,

    Please know its not recommended to install SharePoint on a Domain Controller. A farm setup can be done even with one SQL Server and one SharePoint Server; in your scenario you may choose to run SQL Server on DC and SharePoint on other server.

    Here are some TechNet links which may be useful.


    In the event that you still choose to install SharePoint on Domain Controller, you may run into an issue where you'll get an error message "trial period for this period has expired". You can download a patch http://download.microsoft.com/download/b/1/a/b1a6dceb-92a3-4808-8dac-b4e40c90ce00/StandaloneDCWorkaround.msi for the same.


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Regards,
    Nishant Shah
    Microsoft Online Community Support
    Thursday, October 6, 2011 4:00 PM
    Moderator
  • Hello Nishant Sh

        You say a farm can be setup with one server.

        I thought one server meant standalone.

        That is what has been confusing me.

        Now based on the link I will change how the farm will be
    setup.  There has to be a domain controller or the network won't
    exist but I will create the farm as follows:

    Domain Controller:

        SQL Server
        Exchange Server
        VPN
        DNS
       

    Member Server:

        WFE
        Applicaton Server
        IIS
        EXCEL
        ADOBE

        They say that WFE is where most of the disk space is
    needed.
       
        The question is, if SQL Server is on the domain controller,
    where will Sharepoint databases reside (ie SP_Config, content database etc)?

        Thank you
        Shabeaut

    Thursday, October 6, 2011 8:59 PM
  • You could do your farm as you describe above, with SQL on the DC - but you could equally install SQL on the same host as Sharepoint install DC, setup DNS - install sharepoint server OS - join the domain - then SQL, then sharepoint.

    You config DB etc. will be in the SQL server.  Your WFE requires about 80gig minimal drive space.

    Of course, your setup has no redundancy or fault tolerance - if you have lots of CPU and RAM in those servers then you could virtualize the lot and run a much larger farm with better redundancy across both hardware hosts.


    Regards John Timney http://www.johntimney.com
    Thursday, October 6, 2011 9:59 PM
  • Hello Shabeaut,

    Excerpt from above mentioned TechNet article http://technet.microsoft.com/en-us/library/cc262901(office.12).aspx#section4

    A small server farm typically consists of a database server running either Microsoft SQL Server 2005 or Microsoft SQL Server 2000 with the most recent service pack, and one (or more) server(s) running Internet Information Services (IIS) and Office SharePoint Server 2007.

    In stand-alone configuration, setup routine of SharePoint automatically installs SQL Server Express Edition on the same box and also configures most of the services and provisions a SharePoint Site automatically. But please note, if you choose stand-alone installation then upgrading to a farm installation is not possible without re-creating the SharePoint configuration database.


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Regards,
    Nishant Shah
    Microsoft Online Community Support
    Friday, October 7, 2011 7:38 AM
    Moderator
  • Hello John Timney

        Your recommendation sounds best. 

        I will change the configuration to:

    Domain Controller:

        DNS
        Exchange Server
        VPN

    Member Server:

        SQL Server
        WFE
        Applicaton Server
        IIS
        EXCEL
        ADOBE

    My only remaining question is how can I utilize the
    remaining space on the domain controller?

        Thank you
        Shabeaut


    • Edited by Shabeaut Friday, October 7, 2011 6:10 PM
    Friday, October 7, 2011 6:03 PM
  • Hello Nishant Sh

        I didn't want a standalone configuration.

        I wanted a farm.

        I was confused because I thought both of the
    2 server  need to run Sharepoint.

        Now I understand that my domain controller doesn't
    have to run Sharepoint. Which means my configuration will
    be as follows:

    Domain Controller:

        DNS
        Exchange Server
        VPN

    Member Server:

        SQL Server
        WFE
        Applicaton Server
        IIS
        EXCEL
        ADOBE

    My only remaining question is how can I utilize the
    remaining space on the domain controller?

        Thank you
        Shabeaut

    Friday, October 7, 2011 6:09 PM
  • Hello Shabeaut,

    Again referring back to the same article, if you want to configure SharePoint in farm mode, SQL and SharePoint needs to be on different servers which in the above post doesnt look like.
    Please take time to read the above article and please let me know if you have any questions.


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Regards,
    Nishant Shah
    Microsoft Online Community Support
    • Marked as answer by Shabeaut Tuesday, October 11, 2011 2:41 AM
    Monday, October 10, 2011 9:35 AM
    Moderator
  • Hello Nishant Sh

        I saw your reply and I read the article and was
    going to put SQL Server on the domain controller but
    I didn't understand how the Sharepoint  Content databases,
    SP_Config and the other Sharepoint databases could work with SQL Server
    when they are going to be on the member server.

        Also someone else responded to this post and said I
    could put SQL Server on the member server with Sharepoint.

        But you and the article suggest putting SQL Server on a different
    server so I will put SQL Server on the domain controller.

        Finally it will look like this:

    Domain Controller:

        SQL Server
        DNS
        Exchange Server
        VPN

    Member Server:

        Sharepoint
        WFE
        Applicaton Server
        IIS
        EXCEL
        ADOBE

        We will just have to see how this setup will be able to SQL on domain controller
    work with Content database, SP_Config and the other Sharepoint
    databases that will be able created on the member server.

        Thank you
        Shabeaut

     

    Monday, October 10, 2011 4:42 PM
  • The most important question will be:

    • How many users and data do you plan on accessing the farm?

    If this is less than 100 (just a ballpark since the hardware was not specified) and you keep data within the disk space requirements. This may be acceptable.

    This is a pretty open ended scenario, so if you have additional details that would help with the analysis.

    -victor


    -victor
    • Marked as answer by Shabeaut Tuesday, October 11, 2011 2:39 AM
    Monday, October 10, 2011 7:10 PM
  • Hi Shabeaut,

    I would strongly recommend in reviewing the hardware and software requirements page in the following link:
    http://technet.microsoft.com/en-us/library/cc262485(office.12).aspx

    SQL Server should really be on a dedicated server.

    hope this helps.


    Chirag Patel, MCTS
    Chartered IT Professional
    Blog: techChirag.com
    Twitter: @techChirag
    • Marked as answer by Shabeaut Tuesday, October 11, 2011 2:39 AM
    Monday, October 10, 2011 8:26 PM
  • Hello Shabeaut,

    Why would SP_Config and the other Sharepoint databases be on member (same server as SharePoint) when you install SQL on DC? All the databases too, would be on the SQL Server i.e. MDF and LDF files will be present on the DC box.

    Do you already have an existing SharePoint setup or are you setting up SharePoint for the first time? If you meant you have existing databases, you can move them to SQL Server (DC box).

    If you install SharePoint in Standalone mode ONLY then it will install a local SQL Server however when you install SharePoint in Farm mode, it will ASK for SQL Server details, thats when you can provide the SQL Server (present on DC box) details.

    (Note: Merged duplicate threads, please do not open multiple threads for same issue to maintain clarity on forums)


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Regards,
    Nishant Shah
    Microsoft Online Community Support

    Tuesday, October 11, 2011 9:25 AM
    Moderator