How to get License information from SQLServer installer

Question

We are using SQLServer in our on-prem product.

We need to declare open source license of all the dependencies. How can FOSSA extract license from the installer programmatically without manual installation?

Answer 1

Hi @Lavika,

Thank you for your reaching out and welcome to Microsoft Q&A!

License information is not stored in SQL Server. The license is basically a piece of paper (electronic paper, one would like to hope). SQL Server licenses never expire, so that is the least of your worries.

If you have installed the SQL Server successfully, refer to SERVERPROPERTY (Transact-SQL) => E.g. LicenseType:

"Unused. License information isn't preserved or maintained by the SQL Server product. Always returns DISABLED."

This is a forum for tech issues, I am not familiar with FOSSA, you could try the workarounds from third party blog, hope it can help you!

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications

Answer 2

I don't FOSSA.

If you have the SQL Server installation from an offical download, then the license key is "prepidded" in to it, a simple text file, see

https://sqlserver-help.com/2014/06/05/help-how-to-get-product-key-for-sql-server/

But you have all other license information only "on paper", nowhere in your system.