Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL on a RODC

Posted on 2013-01-09
1
Medium Priority
?
1,152 Views
Last Modified: 2013-03-27
Dear Experts,


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.

regards

Sean
0
Comment
Question by:sgarces
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
James_3 earned 750 total points
ID: 38759904
Microsoft's website says
f you plan to install Microsoft SQL Server 2005 directly on an RODC, you may have to create the appropriate users and groups and ensure that they are replicated to the RODC before the installation. For more information, see article 947986 in the Microsoft Knowledge Base
I believe the same would apply to a newer version of sql server so you would have to create the correct users / groups that the sql server installation requires.
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

604 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