Link to home
Start Free TrialLog in
Avatar of b1dupree
b1dupree

asked on

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.
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

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.
Avatar of b1dupree
b1dupree

ASKER

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.
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.
ASKER CERTIFIED SOLUTION
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial