• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

M/S SQL Server CAL Question???

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
Eric Sherman
Asked:
Eric Sherman
2 Solutions
 
jmoss111Commented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Eric ShermanAccountant/DeveloperAuthor Commented:
Thanks for the reply.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now