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

MS SQL Server Cal

Just confused as to how the CAL thing works.

- Would a website connecting to the database through a single datasource be considered a single CAL?

- Would a store location connecting to an external database via datasource through a single router/IP be considered a single CAL?
0
d_byron
Asked:
d_byron
  • 3
  • 3
1 Solution
 
bwdowhanCommented:
I think you will find that even Microsoft admits that its licensing methods are difficult to interpret. It all depends on which version of the Microsoft application you are running, how it is accessed, and probably a few other factors. The best place for information is the following link:

http://www.microsoft.com/resources/sam/lic_cal.mspx

It explains the various licensing methods for each product (scroll down and choose the one you want).

Good Luck,

Brian
0
 
d_byronAuthor Commented:
I've seen this page before and not being a mssql guru this really doesn't help me.  Based on my criteria (listed again below) does anyone have any further guidance as to if I could get away with using "Workgroup Edition 5 Cal" for a web site (through a single datasource) and a point-of-sale system w/multiple registers at a single store (through single router).  OR would I have to go to Standard Edition with Processor CAL.

- Would a website connecting to the database through a single datasource be considered a single CAL?
- Would a store location connecting to an external database via datasource through a single router/IP be considered a single CAL
0
 
bwdowhanCommented:
d byron,

I checked the various licensing models that we use for our SQL Servers and was told that the CAL model comes in 2 forms:

client CALS - for single user
device CALS - for multiple users on a single device

A device is considered the component that the user uses to access SQL Server, so in this instance, a router is not 1 device. The number of terminals or computers that access the Server through the router are considered devices.

If you have access to your SQL Server through the internet, Microsoft says this about the Per Processor Model, "This licensing model is most appropriate for applications that are accessible through the Internet and for internal applications with a high client-to-server ratio."

So to answer your questions directly:

- Would a website connecting to the database through a single datasource be considered a single CAL?
NO. The users accessing the data source through the website would be considered individual clients.

- Would a store location connecting to an external database via datasource through a single router/IP be considered a single CAL
NO. Each terminal or computer at the store connecting to the server through the router would be an individual client.
If you had a store with 5 front end terminals, and these terminals accessed a SQL Server through a router, you would want to choose the Device CAL because you may have multiple users on each terminal.

I hope that helps!

Brian

0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
d_byronAuthor Commented:
Brian, Thanks for the insight...

I guess I'll have to find out what the low end of pricing is for a processor liscence (any retailers you would recommend?)
0
 
bwdowhanCommented:
d byron,

I wish I knew but I don't really deal with the $$$ aspect of licensing. I just make sure we are covered. I tried looking on Nextag but it looks like all of the pricing includes the SQL Server Software.

http://www.nextag.com/sql-server-processor-license/search-html?nxtg=4bf40a20050a-288B72E4B12E8CE8
0
 
d_byronAuthor Commented:
Thanks so much for the help!  I'll check it out and weigh my options.
0

Featured Post

Industry Leaders: 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!

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