# SQL Server (Server + CAL licensing model) is perspective a Multiplexing/Pooling Device? **URL:** \ **Category:** Ignition\ **Tags:** license, perspective, database\ **Created:** [August 1, 2024, 8:22pm UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091 "2024-08-01T20:22:02Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Julian\_Islic](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/julian_islic/32/57055_2.png) [@Julian\_Islic](https://forum.inductiveautomation.com/u/Julian_Islic)\ **Post date:** [August 1, 2024, 8:22pm UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/1 "2024-08-01T20:22:02Z")
Hey Ignition Team, We are trying to quote a solution for our customer using Microsoft SQL Server Standard Edition as a part of our ignition solution. However, we are planning to use the Server + CAL licensing Model meaning each user/device using the sql server needs an access CAL. Our original assumption is that because the users do not access the SQL server indirectly (table in perspective web page) that we do not have to get CALs for the 20+ operator stations. However, Microsoft produced this document suggesting that indirect access to SQL data is considered Multiplexing/Data Pooling, which requires an access CAL License. > **[multiplexing.pdf](https://download.microsoft.com/download/8/7/3/8733d036-92b0-4cb8-8912-3b6ab966b8b2/multiplexing.pdf)** > > 340.42 KB This means, if we want to stay compliant with Microsoft's terms, each of the clients who need access to SQL data served by ignition must have a CAL. Does anyone know if ignition perspective counts as a multiplexing/pooling device or is this geared more towards software that helps a user interact with the database? For example, visual studio allows you to interact with a database, therefore the user requires a user/device cal. Basically, I want to find out if I have to get 20 CALs for each of the operator stations, or can I get 1 CAL just for ignition? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [August 1, 2024, 8:31pm UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/2 "2024-08-01T20:31:35Z")
IANAL, but I would expect you to need 20 CALs. (This is among the many reasons I do not supply SQL Server to clients.) ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [August 1, 2024, 8:36pm UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/3 "2024-08-01T20:36:12Z")
Our sales engineering team also recommend that you do not use CAL licensing, for the reasons you suspect. ---
**Author:** ![Julian\_Islic](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/julian_islic/32/57055_2.png) [@Julian\_Islic](https://forum.inductiveautomation.com/u/Julian_Islic)\ **Post date:** [August 1, 2024, 11:20pm UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/4 "2024-08-01T23:20:43Z")
Thanks pturmel, I had a feeling this was the case. Unfortunately our customer wants a non open source data base. That basically leaves me with Microsoft and Oracle. @Kevin.Herron I get that, I would prefer Core license too. Unfortunately this is a high speed scenario and Bill Gates charges by the core for some reason. If I am to utilize all 6 cores on my server, I have to buy 3 per core licenses ($3,945 USD per 2 core pack & MOQ 4 cores) for 1 server. Plus they want a redundant server so make that 12 cores total. So the TLDR is it is much cheaper to go CALs at this point. ($989 USD per server + $230 USD per CAL) SMH Microsoft and Oracle, SMH. On top of this, getting support for details on licensing is a huge hassle. Microsoft doesn't like dealing with customers directly, so it usually goes through a 3rd party vendor who struggle to quote a complex system. I wish Inductive was a vendor for SQL server. I like working with you guys. Thanks a million! ---
**Author:** ![michael.flagler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.flagler/32/26272_2.png) [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\ **Post date:** [August 1, 2024, 11:29pm UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/5 "2024-08-01T23:29:12Z")
Make sure your customer realizes that they're probably using more open source software (indirectly) than they realize that's used by many software packages that are not open source, such as: - Ignition - Microsoft .NET (This is directly open source, but used by a lot of software) - Probably many others, but just from the information from your post, they're using both. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [August 1, 2024, 11:34pm UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/6 "2024-08-01T23:34:35Z")
> [@Julian\_Islic](#): > > Plus they want a redundant server so make that 12 cores total. SQL Server Redundancy? Ignition redundancy? Both? ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [August 2, 2024, 12:12am UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/7 "2024-08-02T00:12:24Z")
What an utterly baffling requirement. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [August 2, 2024, 12:40am UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/8 "2024-08-02T00:40:17Z")
> [@Julian\_Islic](#): > > our customer wants a non open source data base Oy! Have they not noticed that both Google's Big Data and Amazon's Red Shift are built on top of PostgreSQL ? And you can use EnterpriseDB's commercial spin of PostgreSQL if you really want the "commercial" label in your own install. (EnterpriseDB is the primary sponsor of PostgreSQL.) In other words, someone has bought Microsoft FUD at a huge premium price. But whatever. They'll have to pay and pay and pay. I will not resell any Microsoft products. At all. I'm happy to _deploy_ on Microsoft platforms that someone else purchases and supports. That's a hard line for me. ---
**Author:** ![msteele](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/msteele/32/77889_2.png) [@msteele](https://forum.inductiveautomation.com/u/msteele)\ **Post date:** [August 2, 2024, 2:58am UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/9 "2024-08-02T02:58:41Z")
> [@Julian\_Islic](#): > > Unfortunately our customer wants a non open source data base. You are not alone, and I commiserate. Sometimes they want to have some DBA who has never looked at an Ignition database to go in with SSMS and figure everything out. But I bet there are suitable IDEs in Postgres world too. ---
**Author:** ![Julian\_Islic](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/julian_islic/32/57055_2.png) [@Julian\_Islic](https://forum.inductiveautomation.com/u/Julian_Islic)\ **Post date:** [August 23, 2024, 2:25pm UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/10 "2024-08-23T14:25:56Z")
I think the customers worry is not so much a security thing, its likely more of a support thing but I am just speculating. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [August 23, 2024, 2:42pm UTC](https://forum.inductiveautomation.com/t/sql-server-server-cal-licensing-model-is-perspective-a-multiplexing-pooling-device/94091/11 "2024-08-23T14:42:13Z")
> [@Julian\_Islic](#): > > likely more of a support thing Paid support is available, from big, stable companies, for all of the open source products I mentioned (and more), as contracts or pay-as-you-go. The support "issue" is the biggest chunk of FUD MS excretes.