1

I am creating a script to install SQL Server via the command line.

I cannot see a way to choose the edition I want to install. The GUI on my install media offers Evaluation, Developer or Express:

(When I choose Evaluation, I can enter the product code)

enter image description here

The ConfigurationFile.ini generated by the installer does not seem to have any sort of reference to the edition that is being installed. Once I run the installer, it installs standard edition (verified by PRINT @@version)

How can I specify the edition I wish to install?

1 Answer 1

3

I found some information about your question.

There is a parameter when you set up on the command line which is /PID.

Check out the document.

Specifies the product key for the edition of SQL Server. If this parameter is not specified, Evaluation is used.

C:\SQLMedia\SQLServer2019> setup.exe /Q 
/IACCEPTSQLSERVERLICENSETERMS /ACTION="install" 
/PID="AAAAA-BBBBB-CCCCC-DDDDD-EEEEE" /FEATURES=SQL,AS,IS,Tools
/INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="MyDomain\MyAccount"

You can use this parameter with the product key.

Evaluation: 00000-00000-00000-00000-00000

Express: 11111-00000-00000-00000-00000

Developer: 22222-00000-00000-00000-00000

Excerpt from the blog of Pinal Dave.

1
  • it works - thanks!
    – SE1986
    Nov 2, 2020 at 20:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.