licenses vs. user connections in SQL 7

licenses vs. user connections in SQL 7

Post by tim » Thu, 10 Jan 2002 05:44:27



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 they
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 access)
and that we are in compliance regarding licensing.
 
 
 

licenses vs. user connections in SQL 7

Post by alex li » Thu, 10 Jan 2002 12:43:37


hi

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
the licencing

cheers
alex lim
avanade malaysia

Quote:>-----Original Message-----
>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
they
>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
access)
>and that we are in compliance regarding licensing.
>.


 
 
 

licenses vs. user connections in SQL 7

Post by Sethu [MS » Thu, 14 Feb 2002 04:28:38


By default SQL server will allow 32767 user connections (checked through
sp_configure)
I would recommend that you talk to your application vendors and make sure
they are talking about "User Connections" and not licenses.
If indeed they are talking about "User connections" as it seems, then you
should be fine as long as you only have not more than 5 machines connecting
to SQL server at any time.

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
Http://support.microsoft.com

 
 
 

1. license muti-users vs one-user ?

Hi,
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
possible PHP4.

Thanks  a lot
C.Tondeur

2. Available Contract Candidates Available, Incl. PeopleSoft and Oracle

3. Moving from 16 user license to 32 user license

4. remote view and the SQL SERVER temporary table

5. informix site vs. user licenses

6. SQL 7.0 Enterprise Manager and DTS Crash on transfer.

7. 5 user licenses of SQL SERVER 7 will hamper 200 users working on intranet applic

8. SQL Syntax

9. Licenses vs. concurrent connections

10. User Connections and Client Licenses

11. Difference between User Connections & License

12. Maximum concurrent user connection ?= Number of license