Link to home
Start Free TrialLog in
Avatar of HilltownHealthCenter
HilltownHealthCenter

asked on

Help with SQL Server licensing

Our non-profit needs to set up an SQL server to be accessed by an application running on a terminal server (TS is licensed for 25 workstations).
I have a 3 CD set of SQL Server 2005, but I don't know what I need for licensing.
Avatar of AriMc
AriMc
Flag of Finland image

The cheapest (free) solution is the Express edition, if you can get along with the limitations:

   http://www.microsoft.com/sqlserver/2005/en/us/express.aspx

Using is allowed regardless of the commercial status of your organization, so it doesn't matter if you are a "non-profit".

ASKER CERTIFIED SOLUTION
Avatar of Lowfatspread
Lowfatspread
Flag of United Kingdom of Great Britain and Northern Ireland 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
Avatar of HilltownHealthCenter
HilltownHealthCenter

ASKER

I am checking to see if the application will support the express version.

The SQL server will be standalone.

 I see that SQL 2008 R2 can can handle 10GB of data, but uses only 1GB of memory. I assume that this means that this version will be very much slower than the next highest (Workgroup) which can use 4 GB? I have an x64 server. Will there be any issue with express?

Is there any issue in express of users licenses?

In a more advanced version, how is licensing handled in a thin client environment?
Upping points. Looks like I will need all the help I can get here.
I am informed that I need the Standard version. So the question remains as to how licensing works with a Terminal Server.
SOLUTION
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
"Server plus Device CALs.  Under this model, a server license is required for each
operating system environment running an instance of SQL Server"

Does this mean that for each thin client session on the Terminal Server running the software will need a device license?
SOLUTION
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