User connection don't have anything to do with CAL.A
computer can issue multiple connection to SQL Server with
one CAL.This is according to MOC kit Administrating SQL
Server 2000.For safe side,you can always make an enquire
at the local microsoft office in your country.i am sure
they will be more than happy to give you the details on
>I am using SQL 7 Server with 5 concurrent client access
>licenses. My question is what do user connections have to
>do (if anything) with CALs? Is user connections merely a
>configuration setting to limit traffic on the SQL server
>or what? I am getting ready to install TSCensus which has
>the option to use SQL server as its database. In their
>manual they have an appendix on fine-tuning SQL where
>talk about how each Manager needs 6 connections, each
>Collection Server needs 5 connections, etc.
>My two main concerns here are that we don't run out of
>licenses (only 5 or less pc's will have concurrent
>and that we are in compliance regarding licensing.
User connections really have nothing to do with CAL's
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
For additional support see
I would like to build an application on the classic 3 tier architecture
(w3 + application server + DB).
I think only one user is needed , but i'm not sure because i don't known
very well Oracle products... If i need different view(differents actors)
in my DB, i can hide the system with the application server, i know
there is a security hole in the application, but i think i can do that.
Can you confirm me ?
I would like to use Apache + WebObjects + Oracle DB and if it's
Thanks a lot
8. SQL Syntax