Windows 2003 Terminal services plan

Posted on 2006-05-16
Last Modified: 2012-05-05
I am planning to setup Windows 2003 server with SQL running an application which runs on the back of SQL.  The software company has advised setting up terminal services and let the ten clients connect in this way for running the sql application and probably file sharing and office.

I have little experience of Terminal services, Can anyone tell me how troublesome this type of setup is, I'm also concerned with what spec of server I would need, so any advise is appreciated.

Question by:Sid_F
    LVL 8

    Accepted Solution

    Terminal Services is pretty straight forward.  The main issues people run into are not understanding the application setup under SQL and mistakes on security.

    Application Setup for the application itself should be done AFTER the system is set up as a Terminal Server.  The setup is done using the Add/Remove programs in the registry.  Basically windows wants to see what keys and directories are modified so that it can set appropriate security permissions.  If you are running the SQL on the same box as the TS, that should be fine to set up before the terminal services are added to the box.  Also, Terminal Services Licensing you should consider setting up a domain TS Licensing box on another server if you are using a domain.  Last, but not least, it is possible under the Administrative Tools / Terminal Services Configuration to set the properties for the connection.  You can set the timeouts for users and the like.  You can even set up that the user gets not a full desktop, but JUST your SQL application which can be good for security.  

    Here is an article on setting the security on the server:

    As for Spec of server, terminal server is actually pretty efficient on usage.  It largely depends on the app and how much umph it requires.  Since this is a production box I would certainly give it some sort of raid.  Usually the more ram the better as well.  For a moderate application with 10 users you could use a dual core 2.8, 2-4 gigs of ram, and 3 hdd's connected to a 3ware raid controller.  For a heavier cpu useage app you could change that to dual xeon's.

    Hope that helps!
    LVL 5

    Author Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Preface Having the need * to contact many different companies with different infrastructures * do remote maintenance in their network required us to implement a more flexible routing solution. As RAS, PPTP, L2TP and VPN Client connections are no…
    This may not be a text book method to resolve VSS backup issues but it seemed to have worked on few of the Windows 2003 servers we had issues while performing a Volume Shadow Copy backup. If you have issues while performing a shadow copy backup usin…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now