Freigeben über

SQL Server 2008 & Windows Server 2008 RODC

  • Artikel

One of the many interesting new features in Windows Server 2008 is the Read Only Domain Controller (RODC).  Simply put , the RODC can only be updated by another Domain Controller i.e. NOT directly.  It is designed for the branch office and caches the credentials of the users in that branch and saves users then having to round trip to the main domain controllers back at head office. This really comes into when the link to Head office breaks as the local users can still login using the RODC. 

In the same way these branch offices often need to run SQL Server locally, this might then have replication set back to head office to give maximum local performance when the links to head office are slow and/or unreliable.

There is some debate at the moment about the need for SQL Server 2008 will be supported on Windows Server 2008 when it runs the RODC role.

I am using the word supported here in the Microsoft sense of the word i.e. if it’s broken Microsoft will fix it and support you in the process.

In my opinion SQL Server 2008 needs to be supported on an RODC as you really only want one server in the branch.  One way to shoehorn all of a branches applications onto physical server would be to use Hyper-V i.e. to create a virtual machine on top of the physical RODC server with all the application stuff. Virtualising SQL Server in a production environment is a frequently debated topic in its own right, but might work in this scenario as SQL Server is unlikely to be maxed out in this scenario.

So if branch offices figure in your SQL server estate, please let me know what you think about any of this.

Technorati Tags: Windows Server 2008,Read Only Domain Controller,RODC,SQL Server

Comments

  • Anonymous
    February 19, 2009
    The comment has been removed

  • Anonymous
    February 23, 2009
    Michael No there aren't our advice is to run windows server 2008 hyper-v at each branch with a vm for the RODC and another for SQL Server 2008.  You can then quickly deploy/patch these VM's to each branch. Andrew

  • Anonymous
    May 01, 2010
    I'm install Sql Express 2008 r2 on RODC 2008 r2. Before install i'm create manually group SQLServerMSSQLServerADHelperUser$ServerName.

  • Anonymous
    May 01, 2010
    I'm install SQLExpress 2008 R2 on RODC 2008 R2. Before install I'm create manually group SQLServerMSSQLServerADHelperUser$ServerName.

  • Anonymous
    December 01, 2010
    Here is manual (in russian) how to install SQL 2005 on RODC www.leann.ru/.../90-installing-sql-2005-on-rodc-windows-server-2008

  • Anonymous
    December 05, 2010
    Evilleo, yop it's easy to do in any lnaguage - it's just not a supported sceanrio and that matters to a lot of customers who want support from Microsoft