Menu
Can I use free SQLServer Express in my commercial windows project? Are there any license issues? How many nodes it supports in multiuser environment ?
787
Microsoft SQL Server Express is free for commercial use so no additional licensing needs to be purchased. Express Edition is an entry level database server which is limited to being able to use only 4 processor cores and 1 GB of memory per instance. The database file itself is limited to a maximum size of 10 GB.
SQL Server Express may only be used at no charge for development and testing, as well as for “micro workloads” such as mobile or web apps with minimal relational database requirements. The free license does not apply to instances running on virtual machines. There are two versions of SQL Server Express.
With the introduction of SQL Server 2016 Microsoft has made the SQL Server 2016 Management Studio a free download (still you need a 'license' and agree with the terms, but you do not have to pay Microsoft any money).
Express edition limitations Microsoft SQL Server Express has a 10 GB maximum database size and other important limits. High load scenarios are not supported by Express. Symptoms can include database connection errors. Express has a "LocalDB" preset.
Quick answer is Yes. I have heard of MS themselves say it is OK. See this MSDN forums thread.
126
SQL Server Express is distributed for free and can be used reliably in any small business application.
The Wikipedia article is quite good at highlighting the key drawbacks of using an Express edition compared to a commercial SQL Server instance. Most notable perhaps is the lack of a SQL Server Agent process, which is usually used for job scheduling.
39
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
