SQL - Just create a new instance?

[Codename K]

Hello,

In some computers SQL Server Express may be already installed. In this case, the installer only needs to create a custom instance. How to do it?

[Daniel]

Hello,

In this case you can configure your "SQL Server Express" prerequisite to be always installed (from "Prerequisite Install Conditions Tab") and, then in the "Install Command Lines" fields (from "Prerequisite Setup Files Tab") add a proper command line which will install a named instance.

Let us know if this helped, otherwise please offer us more details about your requirements.

All the best,
Daniel

[EstebanLopez]

Hello Daniel,

I know this post is fairly old but I would like to know how to create an instance without using the Command Line in the prerequisites. The reason is that I want my database to be installed in a custom instance (other than SQLEXPRESS) and if the user already has SQL Server installed, the Command Line won't be executed, hence he won't have the custom instance I want.

Greetings,

Esteban.

[Daniel]

Hello Esteban,

Have you configured your "SQL Server Express" prerequisite to be always installed (from "Prerequisite Install Conditions Tab")? If not, can you do so and try again the prerequisite installation by using a specific command line for named instance installation?

All the best,
Daniel

[EstebanLopez]

Hello Daniel,

Thank you for your answer, I have tried the Always install prerequisite option but it doesn't meet my requirements, I don't want my users to see the install prerequiste window if they have my custom instance and SQL Server Express installed.

Greetings,

Esteban.

[Daniel]

Hello Esteban,

Can you please give us more details (maybe exemplify a bit) about the behavior you want to achieve so we have a clear view of your requirements?

All the best,
Daniel

[jvsanguyo]

Hello Daniel,

Thank you for your answer, I have tried the Always install prerequisite option but it doesn't meet my requirements, I don't want my users to see the install prerequiste window if they have my custom instance and SQL Server Express installed.

Greetings,

Esteban.

This is my problem also. If the machine is having the SQL INSTANCE named SQLEXPRESS the prerequisites (SQL SEVER EXPRESS) should skip else install SQL SERVER EXPRESS.

[Daniel]

Hello,

This is my problem also. If the machine is having the SQL INSTANCE named SQLEXPRESS the prerequisites (SQL SEVER EXPRESS) should skip else install SQL SERVER EXPRESS.

To install your SQL prerequisite only when the "SQLEXPRESS" is not already present on the local machine you should use in the "Prerequisite Install Condition" tab a registry search which will look for the "SQLEXPRESS" instance.

All the best,
Daniel