--- title: SQL Server BI Edition (Licencing) now makes sense! description: SQL Server BI Edition (Licencing) now makes sense! --- [![](https://www.coeo.com/wp-content/themes/coeo/images/logo.svg)](https://blog.coeo.com/) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) | [Client portal login](https://my.coeo.com) # SQL Server BI Edition (Licencing) now makes sense! # The Coeo Blog ![Les Reading](https://blog.coeo.com/hubfs/Icons/Logo%20no%20strapline.jpg) Under the SQL Server 2012 licencing terms running a data warehouse on the BI edition of SQL Server did not make sense if your source databases were licensed per core. This was due to the multiplexing rule which, in effect stated that all users who either added data or read from a database had to be covered by a CAL if that database was on a BI edition SQL Server, regardless of how their data ended up in, or was extracted from the BI edition database. This was particularly annoying if you ran a website and your web databases were on servers licensed per-core and you then ran an ETL or batch process to put data into a data warehouse which only a small fixed number of users would run reports from. In effect you had two choices, build your data warehouse on Standard or Enterprise editions licensed per-core, or purchase a CAL for every user of your website who created data that would pass through the ETL process and end up in your data warehouse. Under SQL Server 2014 the multiplexing rule appears to have been relaxed and the new licencing datasheet states: ***Business Intelligence Server Access *** *Similar to other SQL Server products offered under the Server + CAL licensing model, Business Intelligence (BI) Edition generally requires a SQL Server CAL for each user or device accessing the server software. New with SQL Server 2014, use terms for BI Edition server software now allow batch processing of data without requiring CALs for those data sources supplying the data. * - *‘Batch Processing’ is defined as an activity that allows a group of tasks occurring at different times to be processed together at the same time. * - *Non-batch processing access to BI Edition servers still requires CALs be assigned to those users and/or devices accessing the server software. * - *The general multiplexing policy still applies to SQL Server Standard and Enterprise Edition software licensed under the Server + CAL model. * The obvious beneficiaries of this rule are the online industry who have many users that will create data, e.g. retailers, insurers, gaming websites and so on, which then gets processed and placed into a data warehouse or cube accessed by only a small number of internal users.   The 2014 licencing datasheet can be downloaded from here: [Microsoft SQL Server](http://www.microsoft.com/en-us/server-cloud/products/sql-server/Buy.aspx#fbid=v-LgdfzaMYf)   ### Subscribe to Email Updates ## Related posts --- ### [Troubleshooting Ola Hallengren’s Maintenance Solution](https://blog.coeo.com/troubleshooting-ola-hallengrens-maintenance-solution) ### [Domain-Independent Windows Failover Cluster for SQL Server AlwaysOn Availability Group](https://blog.coeo.com/domain-independent-windows-failover-cluster-for-sql-server-alwayson-availability-group) ### [SQLBits 2022 session - Field Testing Ola Hallengren’s Maintenance Solution](https://blog.coeo.com/sqlbits-2022-session-field-testing-ola-hallengrens-maintenance-solution) ### [Windows Active Directory Detached Cluster with SQL Server Basic Availability Group](https://blog.coeo.com/advanced-sql-server-windows-cluster-options) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | info@coeo.com ## Contact Us By clicking submit below, you consent to allow Coeo to store and process the personal information submitted above to provide you the content requested. You may unsubscribe from these communications at any time. For more information on how to unsubscribe and our commitment to your privacy, please review our **[Privacy Policy](https://www.coeo.com/privacy/)**. ## Upcoming Events [See all events](https://www.coeo.com/events/) #### NOW Building, Thames Valley Park Drive, Reading, RG6 1RB [![](https://www.coeo.com/wp-content/themes/coeo/images/social-glass.png)](https://www.glassdoor.co.uk/Overview/Working-at-Coeo-EI_IE959052.11,15.htm)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-in.png)](https://www.linkedin.com/company/coeo-ltd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-twitter.png)](https://twitter.com/CoeoLtd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-fb.png)](https://www.facebook.com/coeoltd/) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-icon.png) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-close.png) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) - [Solutions](https://www.coeo.com/solutions/) - [Next Steps](https://www.coeo.com/next-steps/) - [Dedicated Support](https://www.coeo.com/dedicated-support/) - [Case studies](https://www.coeo.com/case-studies/) - [Technologies](https://www.coeo.com/solutions/technologies/) - [Industries](https://www.coeo.com/industries/) - [Finance](https://www.coeo.com/industries/finance/) - [Retail](https://www.coeo.com/industries/retail/) - [Technology](https://www.coeo.com/industries/technology/) - [The Team](https://www.coeo.com/people/) - [Join Us](https://www.coeo.com/careers/) - [Graduate Programme](https://www.coeo.com/graduate-programme/) - [About Coeo](https://www.coeo.com/about-coeo/) - [The Coeo Blog](https://www.coeo.com/blog/) - [Contact us](https://www.coeo.com/contact-us/) - [Privacy Notice](https://www.coeo.com/privacy/) - [Cookie Policy](https://www.coeo.com/privacy#Cookie_Policy) - [Events](https://www.coeo.com/events) Sign up to our newsletter ![go arrow](https://www.coeo.com/wp-content/themes/coeo/images/newsletter-go.png) Back to top