sms 2003 -- can i have two sql server in a active directory forest

Posted on 2005-04-28
Last Modified: 2010-04-18
Hi all experts,

I have a domain called "" and a child domain called "".

The question is --
1. Can I have a primary site server in "" and another primary site server in ""?

2. Can I set the primary site server (from now I call it A) in "" the parent site of the primary site server (from now on I will call it B)  in ""?

3. If question #2 is yes, is A the central site of my forest?

4. If question #3 is yes, can I have a report of all the information of all sites?

Thanks.. if there is any doubt .. let me know.
Question by:mohai
    LVL 1

    Author Comment


    I am doing this is because I want to have 1 SQL in each of my site...
    LVL 3

    Accepted Solution

    you want have any problems.
    I'm using 4 SQL servers in my domain (and childs) and i didn't experience any problems...



    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Windows 7 Updates 11 67
    Server 2000 functional level to server 2008 r2 5 59
    Dentrix G4 1 14
    RDP up only between 8am-13.00 pm ? 11 48
    Organizations create, modify, and maintain huge amounts of data to help their businesses earn money and generally function.  Typically every network user within an organization has a bit of disk space to store in process items and personal files.   …
    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now