What is the recommendation of installing Remote Desktop on SBS 2008 OR on Server 2012 R2 running SQL?

What is the recommendation of installing Remote Desktop on SBS 2008 OR on Server 2012 R2 running SQL?  What would be the best way to go?
Thanks.
b1dupreeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lee W, MVPTechnology and Business Process AdvisorCommented:
SBS does not permit RDS services.  The BEST way to go would be to virtualize the 2012 R2 install, use 2012 R2 with Hyper-V to host the SQL install AND install a SECOND VM for RDS.  That would be the best way to go.  If 48 GB of RAM and SAS based drives aren't enough, increase your hardware specs - more RAM, SSD drives, second CPU and/or more cores if the mainboard supports it.
0
b1dupreeAuthor Commented:
Thanks Lee.  I can't go virtual on SQL because the LOB publisher won't support it.
What about installing Remote Desktop on the SQL Server--good or no?
Thanks.
0
Hypercat (Deb)Commented:
It all depends on the number of users and size of the database, but generally I wouldn't recommend it.  I do have one client where I have this config, but there are only 1 or 2 users who use the remote desktop on a regular basis.  And in fact it's not 2012, it's a 2003 server, so the effects on performance might be quite different between the two OS versions.
0
Lee W, MVPTechnology and Business Process AdvisorCommented:
In most cases LOB companies won't have a clue. Exceptions generally being for LOB apps that have hardware keys. That said, the LOB app probably could run on SBS leaving SQL ( which is supported by MS in a virtual environment to run on a vm that you can pair with a vm for RDS.

As I said on the list, no one at MS is going to recommend SQL on an RDS server. You didn't mention the LOB app on the list but with that condition I wwould be telling the client they need a New server Or a New LOB app that supports modern technology and technology trends. If there just isn't any option I would sell this As a short term solution only and go ahead with rds and sql on the same box.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.