few questions with very short answers RRS feed

  • Question

  • I am preparing my self for sbs 2008 examen so I have few questions .a very short answer is enough'.

    1_can you use sql server failover clustering  in sbs 2008  or it does not support this functi2on?

    2 -member domain can replicate domain controller or you must promote it first to use as domain replicator

    3-kan you install sql server in sbs 2008 in the same partitie?(for exampe partitie c: )

    4-when i try to install sql server on domain he asks me witch module do you want to install express mode or enterprise evaluate mode ,witch mode do I have to choose?

    5-where I can find SID to make some permission changes?(in witch tool)

    6-I read that sql sever does not run under local service account or network service account,but I installed the sql server on the same partitie  as the 2008 standaard edition.does it make ony problem?

    thanks hovhannes  very short answers is enough

    Tuesday, October 12, 2010 9:22 AM


  •  1. No, SBS 2008 does not support failover clustering (and thus does
    not support SQL failover clustering)
    2. If I understand your question properly, a member server does not
    replicate anything in the domain, it must first be promoted to be a DC
    3. SQL Server can usually be installed on the system partition if there
    is enough space (though it may not be a recommended practice)
    4. Either, it depends on your needs. Express is free, but is subject to
    some serious limitations and is only for very small DBs. Enterprise
    evaluation needs to be activated with a real key within 180 days
    otherwise it becomes unusable.
    5. I usually use LDP personally, but you can use a number of tools.
    I'm not sure why you would need the SID to make perms changes
    since these are usually resolved.
    6. Usually you have dedicated managed service accounts (in Windows 2008
    ) or dedicated domain user accounts, but you can also create local
    accounts to run the services. See the following for details on this,
    For the second part of the question, it is the same answer to (3) above.

    -- Mike Burr
    • Proposed as answer by Diego Piffaretti Wednesday, October 20, 2010 4:20 PM
    • Marked as answer by Rubel Khan Thursday, October 21, 2010 3:21 PM
    Tuesday, October 12, 2010 12:12 PM