Solved

M/S SQL Server CAL Question???

Posted on 2008-10-01
3
238 Views
Last Modified: 2012-05-05
I have a client that will be converting their Accounting Sys to a version that runs on M/S SQL Server.  We have two separate Front-End applications developed in Access/VBA that connects to the Accounting Sys using a DSN and ODBC connection to link up with specific tables (5).

The question is how to determine the number of CAL's that will be needed??  When I presented this question a few months ago the answer was pretty straighforward in that if 20 workstations will run the Access Front-End application then you will need 20 CAL's.

My thinking is  ... and this is what I'm trying to make sure of and confirm ....  Say if a workstation connects to the SQL Server, links up to the 5 tables but doesn't do anything but sits there.  Will that CAL be freed up or will it still be counted as a CAL in use by SQL Server???  My thinking is the License is only counted as in use when something in the Access Front-End application executes something against the SQL Server, is that correct???

Thanks,

ET



0
Comment
Question by:Eric Sherman
3 Comments
 
LVL 18

Accepted Solution

by:
jmoss111 earned 250 total points
ID: 22616946
I think that CAL's are actually determined by concurrentconnections, but I may be wrong. It would be best to talk to M$ or a VAR.

Jim
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 22617278
I believe as long as the connection is active, the license is considered to be in use. Heed Jim's advice, however, regarding licensing ... the waters be murky there ....
0
 
LVL 19

Author Closing Comment

by:Eric Sherman
ID: 31502065
Thanks for the reply.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Select Query help 1 34
Hide shared folder for some users 2 24
SQL Syntax 6 36
SQL Syntax 6 27
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

685 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