How To Create New Instance In Sql Server 2014

Home
Databases
Microsoft SQL Server

I am trying to add a new instance to SQL 2014 which already has 3 instances running. I opened the SQL Server Installation Center - Installation - New SQL server stand-alone install or add features to existing installation - it is asking for Installation Media.

can someone please help me with this ?

Edited Aug 6, 2021 at 20:49 UTC

6 Replies

Gary D Williams

This person is a verified professional.

Verify your account to enable IT peers to see that you are a professional.

Aug 6, 2021 at 21:19 UTC

Give it the installation media by putting a DVD into the server or mounting the ISO file.

It normally gives the path to where it was originally installed from so you may need to create a volume to simulate the original directory if it has been removed or as Gary says put the DVD in the drive.

Microsoft SQL Server expert

No, it doesn't look for the original path of the install folder when you are installing a new instance. You must have the media you want to install. This is a very basic concept.

I'd suggest that someone that doesn't know this shouldn't be installing a second instance on the server. You'd need to consider memory and CPU constraints on both instances.

when installing a named instance to an existing SQL 2014 server, generally i've seen that it opens up the product key page after you've clicked on the New SQL server standalone installation or add features to an existing install option in the installation center. However, in my case it is asking for the installation media. is it the SQL instance zip file ?

Microsoft SQL Server expert

I have never attempted to use the SQL Server Installation Center. I always knew I needed the install files and left them on the machine or have access to a share with those files. I never run from the CD for that reason.

Supaplex

This person is a verified professional.

Verify your account to enable IT peers to see that you are a professional.

Aug 14, 2021 at 14:23 UTC

spicehead-ekfsl wrote:

can someone please help me with this ?

Download the latest official SQL 2014 ISO from Microsoft Evaluation Center https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2014-sp3 and mount it on the machine where you want to install a new instance. Use the previous approach and point the wizard to that mounted ISO or run setup.exe from that ISO directly to avoid being asked about the installation media. You can also use additional command line parameters for setup.exe so the Installation wizard won't ask you anything at all https://www.starwindsoftware.com/blog/install-sql-server.