Share via

How to get License information from SQLServer installer

Lavika 20 Reputation points
2024-09-24T08:45:24.0366667+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
95 questions
0 comments
Accepted answer
  1. LucyChenMSFT-4874 4,750 Reputation points
    2024-09-25T01:40:57.3333333+00:00

    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

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,501 Reputation points
    2024-09-24T08:50:18.2666667+00:00

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.