Windows Server 20003, Thin Clients terminal services, SQL

Posted on 2007-10-18
Last Modified: 2013-11-21
We are thinking to upgrade our business environment to a Windows Server 2003 and use NCompting thin clients to connect.  We have an application that uses a SQL database and the program vendor is stating they will not support the program running in a terminal environment.  They state that since terminals are actualyl running from the server, that there is physically one computer accessing the SQL database at one time which will cause double entries.

Can someone please confirm/deny the following:

Install of Windows Server 2003
Use nComputing thin clients to connect (that part works fine we tried it)
Running a reservation system that uses SQL
If multiple thin clients are logged in they can function normal or they will create double bookings
Wouldnt the terminal session create seperate sessions with SQL just like physical computers?

thanks for the info.
Question by:compcreate
    1 Comment
    LVL 31

    Accepted Solution

    Yes and no. It really depends on how the backend identifies the frontend. Some 'not-well-written' applications identify the frontend connection by IP address. In this case as you can imagine, with 20 thin clients connected to the server and from there to the backend, the backend sees 20 connections coming from the same IP address and that may cause issues on the software.
    Again this is really application dependent. Some well written ones will have other mechanisms in place to guarantee/identify each unique session (i.e. using a SQL based logon, using SESSIONID - if retrieved using the WTSAPI, etc).
    The key thing here in your case is to test. Deploy the solution in a test environment and see if the backend has no issues with the frontend being on a TS.


    Cláudio Rodrigues
    Microsoft MVP
    Windows Server - Terminal Services

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
    Know what services you can and cannot, should and should not combine on your server.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now