SQL 2014 (or any other versions) Standard - ~Embedded Licensing~

Question

Post reply

SQL 2014 (or any other versions) Standard - ~Embedded Licensing~

Warren Peace

SSCertifiable

Points: 5881
More actions
August 23, 2019 at 10:26 pm

#3674113
Anyone have any insights on how this licensing works and what the "Use Rights" are?
I can't seem to find much about it. Most I gathered (and I could be wrong) is it is dedicated solely to the application that uses it.
No other databases can be on it for any other reasons and no other applications can connect to it.......in theory.
Thanks.
- This topic was modified 5 years, 4 months ago by Warren Peace.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80325 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

frederico_fonseca SSCoach Points: 16167 More actions · Answer 2

this may help http://download.microsoft.com/download/F/C/C/FCC534B7-90B3-464D-8A24-006DF155F769/Windows%20Embedded%20Server%20and%20Microsoft%20SQL%20Server%20data%20sheet.pdf - your best bet is to contact one of the embedded reselers and ask them about it.

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

I'm not sure what you mean by embedded here. Is it your deployment?

SQL Server licensing is the same, AFAIK, for any application. SQL Server licenses by CAL or processor, though few people use the CALs these days as there are restrictions. If you license by CPU core, then any applications can connect.

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 4

maybe you are thinking of Windows Internal Database, which is limited for size and usage

https://blog.sqlauthority.com/2015/09/30/sql-server-what-is-windows-internal-database-edition/

SQL Server Embedded is what is typically called Compact edition, which Microsoft has not updated in a few years, it is limited databases up to 4 GB, and has some other limits as well

https://www.microsoft.com/en-us/download/details.aspx?id=17876

If you really want a free database, I'd use Express, which can hold databases up to 10 GB

https://www.microsoft.com/en-us/sql-server/sql-server-editions-express

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 5

Potentially Edge edition (https://azure.microsoft.com/en-us/services/sql-database-edge/), though no idea when this is coming out.

If you are using Compact, I would think about Express, unless you have a good reason not to. If you really need an embedded version, I think SQLLite or Raven are popular choices.

frederico_fonseca SSCoach Points: 16167 More actions · Answer 6

Found another document - this is a bit more clear on the whole embedded subject.

https://www.arrow.com/arrow-services/msembedded/wp-content/uploads/sites/3/2019/07/windows-embedded-server-decision-tree.pdf

Main difference from "standard" licenses is a longer support period - possibly as Steve mentioned using a SQL Express may be an option - limited on CPU but 10GB per database really means 10GB max per big tables as number of DB's per instance is over 30K - although you won't be able to use that many.

Andy sql SSCrazy Eights Points: 9496 More actions · Answer 7

Also worth familiarising yourself with the licensing terms for redistribution rights:

Microsoft® SQL Server® Express License Terms for Redistribution and Hosting

https://www.microsoft.com/en-us/download/details.aspx?id=29693

Documents:

SQL 2014 Express_Hosting_Redistribution_EULA.docx

SQL Express 2012 Express (Revised).docx

I couldn't find a reference to 2016 nor 2017 though.