Thom-M
Posts: 3
Joined: Tue Feb 08, 2022 2:29 pm

Install SQL Server without asking for Extracted-Files directory

Tue Feb 08, 2022 2:42 pm

Hi,

I'm looking for an installation option to install the SQL Server 2014. The Setup shouldn't be silent, but the user shouldn't be asked for the Extracted-Files directory.

If I include the Parameter "/u", the setup will *correctly* NOT ASK for Extracted-Files directory, but after the copy-process I got finally this error-message:
With_U-Param.jpg
With_U-Param.jpg (92.71KiB)Viewed 11546 times

However, if I don't include the "/u" parameter, the setup will always ask for Extracted-Files directory. But I don't want to ask the user for this directory:
Without_U-Param.jpg
Without_U-Param.jpg (96.54KiB)Viewed 11546 times

This is my Install Command Line (incl. /u)

/IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=SQLEXPRESS /UpdateEnabled=False /x:%TEMP%\SQLInst\ /u

This is my Install Command Line (without /u)

/IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=SQLEXPRESS /UpdateEnabled=False /x:%TEMP%\SQLInst\

So how can i start the SQL Server installation process (incl. Microsoft SQL Server Installation-Dialog), without asking for the Extracted-Files directory?

thank you, TM

Catalin
Posts: 6537
Joined: Wed Jun 13, 2018 7:49 am

Re: Install SQL Server without asking for Extracted-Files directory

Tue Feb 08, 2022 4:22 pm

Hello Thom and welcome to our forums,

If possible, could you please try the command line from the following article (/x <path>):

Install SQL Server 2017 Silently/with BasicUI

and let me know if that helps?

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Thom-M
Posts: 3
Joined: Tue Feb 08, 2022 2:29 pm

Re: Install SQL Server without asking for Extracted-Files directory

Tue Feb 08, 2022 4:52 pm

Hi,

as you can see, I already use this command-param...
ParamX.jpg
ParamX.jpg (18.03KiB)Viewed 11539 times
==
Attached I'll send you the complete AIP-project file. :idea:
Attachments
SQLTestinst.aip
(20.33KiB)Downloaded 261 times

Catalin
Posts: 6537
Joined: Wed Jun 13, 2018 7:49 am

Re: Install SQL Server without asking for Extracted-Files directory

Thu Feb 10, 2022 2:56 pm

Hello Thom,

I am sorry, I did not quite see the parameter in your first post.

I believe this might be the default behavior for SQL Server Express 2014. From what I can see, the extract location is correctly set, however the dialog is still displayed to the user.

To avoid this, perhaps we might need to install it silently using either the "/q" or the "/qs" parameter.

This might simply be a limitation of SQL Server Express 2014, as explained in the following thread from Microsoft's forums:

SQL Server 2014 Express extract file parameter?

Regarding the error, this might happen due to the fact that your prerequisite is not actually installed (the "Continue with the main installation even if the prerequisite isn't installed" option is unchecked in "Prerequisites" page) due to a wrong command line.

Basically, the command line that you are using does not work. It only extracts the SETUP.EXE, but doesn't install it.

You can test this by going to the location where your prerequisite was downloaded and launch it with the same command line:

Code: Select all

/x:%TEMP%\SQLInst\ /u /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=SQLEXPRESS /UpdateEnabled=False
You will see that the setup is only extracted but never installed.

With that being said, please make sure that the command line you are using works outside of Advanced Installer first.

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Thom-M
Posts: 3
Joined: Tue Feb 08, 2022 2:29 pm

Re: Install SQL Server without asking for Extracted-Files directory

Tue Feb 15, 2022 12:36 pm

Thank you,

but what is the correct way to start the SQL Server Setup without asking any path?

I just want the normal "Microsoft installation dialog" to appear (not silent, so that the user can make various settings!).

Or is this not possible?

Catalin
Posts: 6537
Joined: Wed Jun 13, 2018 7:49 am

Re: Install SQL Server without asking for Extracted-Files directory

Tue Feb 15, 2022 2:40 pm

Hello Thom,

Whether this is possible or not, I can not really say.

As far as I tested this, it looked like it may not be possible, but I can not say for sure.

You can try to further investigate this and if you find a command line that works outside of Advanced Installer (e.g. from command prompt), then it should work from within Advanced Installer as well.

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

jermitts
Posts: 1
Joined: Mon Jan 16, 2023 10:58 am

Re: Install SQL Server without asking for Extracted-Files directory

Mon Jan 16, 2023 10:59 am

The syntax is /x<SPACE>[path to folder] not /x<colon>[path to folder]

setup /x foldername works...


Jeremy

Liviu
Posts: 1035
Joined: Tue Jul 13, 2021 11:29 am
Contact:  Website

Re: Install SQL Server without asking for Extracted-Files directory

Tue Jan 17, 2023 2:39 pm

Hello Jeremy and welcome to our forums,

Thank you for sharing your solution with us.

Let us know if you have any questions.

Best regards,
Liviu
________________________________________
Liviu Sandu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Building Installers”