[Last Call] Learn how to a build a cloud-first strategyRegister Now


Windows Server 20003, Thin Clients terminal services, SQL

Posted on 2007-10-18
Medium Priority
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

Cláudio Rodrigues earned 150 total points
ID: 20104643
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Have you considered what group policies are backwards and forwards compatible? Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

830 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