With these User CALs, each licensed user will have full access to all devices within your Microsoft SQL Server network.
The Licensing model is a little bit different than the rest of the BPS installation types. Add up to 5 users to Microsoft SQL Server 2016 with this 5 User CAL pack from Microsoft, now available to download instantly here at Trusted Tech Team.
The UsersCals table is only applicable in WEBCON APPS Subscriptions. Device CALs are intended for the clients/endpoints accessing the Windows Server (for any reason to get an IP address, to access a file, to authenticate to AD, to access an application of any type on the Windows Server, etc.) User CALs are intended for the same reason but are assigned to the users using the clients/endpoints. My only idea is, that you are running out of Cals and you need to release one. I hope there is some helpful information here and in the posts. If you are having trouble with choose fields/sql statements you could spend a few minutes here: The numbers in the images refer to the numbers above. If you are executing this on the Task Assignment Workflow, you could simply use the Login option for the field from the Values tab JOIN UsersCals as A ON A.UCL_BpsID = 'ID OF USER'Ĥ. Without knowing the data I would guess, that this should return the same data: I don't see the reason for using the CacheOrganizationStructure. If is a user/choose field, you should use "Database field name - Id"ģ. JOIN UsersCal <- there is an s missing, it should be UsersCalsĢ. Hi all I need to create an email alert that will be triggered if a Task Assignment Workflow is created. Purchase licenses for as little as 1 user, or as many users as needed. So take the following suggestions with a grain of salt, since I couldn't test them.ġ. SQL Query to get the User Cal in a workflow. Buy SQL Server CALs with low monthly cost, and no contract commitments. The feedback on this thread seem right on tracks and affirms what I've been finding.I wanted to test it, but for some reason my UserCals table is empty. on this document explains the SQL CAL's: Number 5 on this Q&A explains the Windows CAL's. "They will still require a CAL, any server access requires a CAL except as mentioned before, when running a WEB or HPC workload or 2 users or devices administering the software." Joshua: What about Windows Server CAL's for the users accessing this website? Each will have an application specific (non active directory) login.
Or up to 2 users or devices to administer the server software.Īs for SQL, you must license every user or device accessing directly or indirectly, and in the case of the application you will be running that is considered multiplexing, and every user or device that access through that application needs to be licensed too." "The only time you will not need a CAL for Windows Server is when running a Web or HPC workload. I initiated a chat with a Microsoft Licensing rep and this is the reply I received from them.
I've reached out to the vendor of the software we will be purchasing and have yet for them to provide a response. I've been doing more research and want to share my findings. If I do need SQL CAL's for all the website users I need to evaluate if it makes more sense to license SQL server per core and not need to worry about CAL's. I'm not getting a clear, consistent answer regarding the website/IIS portion of this. Let's say we setup 50 employees to have access to this website, would I need 50 more user SQL CAL's or not. This website multiple staff will have credentials to - this will allow them to login and view department budgets, etc.
There is also a website as part of this software that runs in IIS and would access data in SQL server. We will have five users licensed to use this program, therefore I know I will need 5 SQL user CAL's and should be good.
There are two parts of the program needing the SQL database. If you license per device, every device (phones, laptops, desktops, printers, etc.) has to have a SQL Device CAL. If you license per user, that user can access the SQL data/internal database application, regardless of the number of devices they use. Trying to figure out what I need for SQL CAL's and am finding/being told conflicting things. Every User or Device accessing SQL data either directly or indirectly requires a CAL. We have a new accounting application we will be adding in the next few months that requires SQL Server Standard (in lieu of express).