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


SQL Server App via Terminal Services / Processors

Posted on 2009-05-18
Medium Priority
Last Modified: 2012-05-07
I have two servers: Server 2003 Enterprise, which is my Terminal Server.  SBS 2003 Premium, which is my domain, file, DHCP, and SUS server.

After confirming with the software vendor, I am planning to merge five clinical software databases into one installation of SQL Server for ease of reporting. In the proposed scenario, users from four remote sites would log in via Terminal Services to use these databases.

In order to do this, I will purchase the full version of SQL Server. I can get a processor license to avoid having to get CALs. On my multi-core processor, I would only need one license. However, this machine is not the Terminal Server, it is the domain server and also is the DHCP, DNS, WSUS, and file server. All of the user folders and the shared directory are on this one. This server has the hard drive space and the power. The Terminal Server does not have the HDD space, plus it has two separate processors forcing me to buy two CPU licenses (I can't).

Please note this is a very small LAN. The whole organization has less than 50 people; my LAN where the servers reside has about 25, so these servers are not being pushed at all. They have plenty of CPU power and a lot to spare.

Because of serious budget limitations, I would need to install SQL with the databases on the SBS server. It would work like this: Users would log in using RDP to the 2003 Enterprise Terminal Server. Then from their remote desktop via a mapped drive, they would access the SQL databases which are installed on the SBS server.

Will this work? (Please hold the security lectures - I am with a nonprofit and money is very limited. Yes, I do buy my software from TechSoup).

Thanks, everyone.
Question by:Cathylb
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 11

Accepted Solution

Abhay Pujari earned 1500 total points
ID: 24421206
As far as your situation is concerned, I think this is possible. You can do this. But there can be a issue of security. If you have a firewall and good antivirus software, then you can always minimize the attack. Also you can implement VPN which is more secure.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

618 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