SQL on a RODC
Posted on 2013-01-09
I believe I already know the answer to this question as I have done abit of research on It already but I was wondering whether any of you had found a work around or correct way of doing it.
I have a Windows Server 2008 R2 SP1 Read Only Domain Controller at one of my sites.
We have just put this in as we are doing upgrades from our previous 2003 servers.
There used to be a Windows Server 2003 Sp3 server on site which was both a file server and a full SQL Server 2003 standard . Our users at site currently use an application that utilises the old SQL database. Luckily I didn't get rid of that server because I have been unable to install SQL Server onto my new flashy RODC. From what i understand this is because my server is a RODC and if it was a Full DC then I would not have this issue even though it is not recommended that you install onto a DC, or if my server was just a member server.
However because the SQL database is on an old piece of kit at end of life I need to get it moved off and onto this nice new flashy server, but I am not comfortable making it a Full Domain Controller, and I want to keep the benifits I am gaining from having it as a RODC. Is there a work around which will allow me to run the latest version of SQL on my RODC? or are my only options to either promote it to Full DC or to have only as a member server. The new SQL installation can either be a Full SQL installation or SQL Express, but I don't believe that really makes a difference. The Database it goes onto does not neccessarily need to be a SQL Database aslong as there is a migration process to get the data from the SQL to the new system.
Looking forward to your answers/suggestions.