Office 365 SQL Licencing

Posted on 2014-04-02
Last Modified: 2014-11-12
We are looking to move to office 365 from our software assurance agreement from Microsoft and while there is quite a lot of documents online about licencing I can’t seem to find answers to the following questions. Any help or links to documents would be very useful.

If we go down the route of office 365 with the E3 plan do we get the following?

•      CAL’s – I can see we get Lync, exchange, and SharePoint CAL’s but I can’t find anywhere whether we need to purchase SQL CAL’s for Lync/SharePoint for office 365. Do we need to provide a hosted SQL server i.e. in Windows Azure or is this all included in the price? My thoughts are as it is hosted and subscription based we won’t need SQL CAL’s or a SQL licence.

•      Are licences for on premise Exchange, Lync, SharePoint included? Would we just need to pay for the Windows server licences? Just curious if we go down the hybrid route.

•      Just to confirm do we just need windows desktop O/S Licences and an office 365 subscription to use all the features of office 365 such as Lync/SharePoint enterprise.

Question by:Reapit
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 21

Assisted Solution

by:Jakob Digranes
Jakob Digranes earned 50 total points
ID: 39971917
Included with Office365 Enterprise you get CALs to use both in cloud and on-premise, this goes for Lync, Exchange and sharepoint. You don't need a SQL server for Office 365 - as you get Software as a Service (SaaS), that means that evertyhing is ready and installed for you.
Azure is Platform/infrastructure as a Service (Paas/Iaas) and you need to install, buy and maintain lync server, DCs and exchange yourself...

You need separate licenses for on-premise servers

All local computers need OS license, but you can get Office licenses with the E3/E4 plans
LVL 12

Assisted Solution

Jeff_Schertz earned 50 total points
ID: 39972369
You may not need separate server licenses for any on-premises servers as typically those higher E3/E4 plans include this.  So if you buy the entire package but still wish to deploy Lync on-premises for Enterprise Voice instead of using the Lync Online services you have already paid for Lync.

That being said it's best to ask a Microsoft enterprise sales representative these questions as the licensing models are often changing and I can never keep them 100% straight myself.
LVL 40

Accepted Solution

Adam Brown earned 100 total points
ID: 39973035
Here's how Office 365 works...You don't really have CALs. You have Licenses that are directly assigned to accounts that exist in Office 365. Office 365 gives you the ability to have On-premise servers, but those servers can really only be used to provide accessibility or management to the services in Office 365. For instance, with Exchange Online, you are allowed to have a Hybrid server in your on-premise environment without having to pay for a license. However, that server cannot be used to host any user mailboxes. It can only be used to provide mailflow and management capabilities for your on-prem accounts. With Lync, you would can have an On-prem server, but it would only allow you to manage the AD accounts that are used in Office 365. For Sharepoint, there really isn't anything you can do with an on-prem server. Sharepoint has No Hybrid functionality.

With Office 365, you are essentially lumping your data into the same environment as everyone else in Office 365. Your data will physically coexist on the same servers and equipment that other Office 365 customers use, it's just logically segregated and separated. I wrote a blog on the subject a couple weeks ago that gives a better explanation:

Basically, with an Office 365 account, you are not paying for servers that are dedicated to you. You are paying for storage space, mailboxes, and accounts that are configured in the same infrastructure that everyone else uses.

If you are looking to have your own entire servers in Microsoft's Cloud, you would instead want to be looking at the Azure Infrastructure as a Service (IaaS) offering, which you can read about here:

In *that* situation, you would basically either extend your AD to Azure's cloud network with a VPN tunneling solution, and then have VMs that run your infrastructure in the cloud. You pay an hourly fee for the resources you have in the cloud and do not have to worry about CALs/Licensing fees for those systems. So if you bought an Exchange 2013 VM in Azure's IaaS cloud, you would receive the VM and the cost of that would include all licensing fees.
LVL 21

Expert Comment

by:Jakob Digranes
ID: 39975119
well; I don't argue with @Jeff_Schertz ;)

Author Comment

ID: 39978418
Thanks for your responses.

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit If you want to manage em…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question