CODEWITHSUNDEEP
sql-server
Devashri B.
Devashri B.

Reputation: 2703

SQL Server Installation - What is the Installation Media Folder?

I am installing SQL Server 2008. I have installed .NET framework 3.5. Then I got folder SQL Server 2008 and performed following steps-

  1. I clicked configuration Tools.
  2. Then I clicked SQL Server Installation Center.
  3. I clicked "Installation" hyperlink on left side.
  4. Then I clicked "New SQL server stand-alone installation or add features to an existing installation"
  5. Then I got a window "Browse for SQL server Installation Media"

Which folder should I choose? Or is there any other method to install SQL Server?

Upvotes: 171

Views: 392503

Answers (13)

HadyKh
HadyKh

Reputation: 73

I found this one without any solutions. I am using SQL server 2019. you can do the following:

  1. download the sql server 2019 from [here] https://www.microsoft.com/en-us/sql-server/sql-server-downloads

  2. open the installer.exe and choose the Download media option enter image description here

  3. choose the iso option enter image description here

  4. after a while you will get a .iso file extract it in a folder it will give you file like this enter image description here

  5. the folder that you had extracted in it is the folder to be chosen hence it is the "Browse for SQL server Installation Media" target

hope that this helps you

Upvotes: 3

Waldron
Waldron

Reputation: 124

I downloaded from https://my.visualstudio.com/Downloads

It gave me an iso file (en_sql_server_2017_standard_x64_dvd_11294407.iso)

I had to double click on it and then it gave me an E: drive on my computer.

Then I was able to select the E: drive when it asked for the Installation Media location.

Upvotes: 0

Luis Leuppi
Luis Leuppi

Reputation: 78

I had to select the folder C:\SQL2019\Express_ENU for it to work.

Upvotes: 3

Swanand Pangam
Swanand Pangam

Reputation: 898

For the SQL Server 2019 (Express Edition) installation, I did the following:

  1. Open SQL Server Installation Center
  2. Click on Installation
  3. Click on New SQL Server stand-alone installation or add features to an existing installation
  4. Browse to C:\SQL2019\Express_ENU and click OK

Upvotes: 19

Abdul Hannan
Abdul Hannan

Reputation: 424

For me the Issue was I didn't run the setup as Administrator, after running the setup as administrator the message go away and I was prompted to install and continue process.

Upvotes: 1

Adam Vincent
Adam Vincent

Reputation: 3811

For SQL Server 2017

Download and run the installer, you are given 3 options:

  1. Basic
  2. Custom

  3. Download Media <- pick this one!

    • Select Language
    • Select ISO
    • Set download location
    • Click download
    • Exit installer once finished

  4. Extract ISO using your preferred archive utility or mount

Upvotes: 1

Rhys
Rhys

Reputation: 2173

For the SQL Server 2017 (Developer Edition) installation, I did the following:

  1. Open SQL Server Installation Center
  2. Click on Installation
  3. Click on New SQL Server stand-alone installation or add features to an existing installation
  4. Browse to C:\SQLServer2017Media\Developer_ENU and click OK

Upvotes: 114

Marnix van Valen
Marnix van Valen

Reputation: 13673

I ran into this just now with SQL Server 2014 SP1. The installer gave me the exact same problem and I followed suggestions from other answers to this question, but it got me nowhere.

In the end I figured out that I needed to download and install SQL Server 2014 first, and then apply SP1 to it. (doh)

Upvotes: 3

Serdar KUŞ
Serdar KUŞ

Reputation: 404

Problem is about too long setup file name. Change setup.exe parent folder name(short a name). And try it!.

Upvotes: 0

Omer Faruk Celebi
Omer Faruk Celebi

Reputation: 268

While installing SQL Server, it extracts contents to temp folder under C directory. You can copy that folder after extraction finishes and then use that one for browsing

Upvotes: 6

Watki02
Watki02

Reputation: 4866

If you are using an executable,

  • just run the executable (for example: "en_sql_server_2012_express_edition_with_advanced_services_x64.exe")
  • Navigate to the "options" tab
  • Copy the "Installation Media Root Directory" (should look something like the below snipping)
  • Paste it into the open "Browse for SQL server Installation Media" window

enter image description here

Save yourself the hastle of renaming and unzipping etc.!

Upvotes: 47

Killing by Issues
Killing by Issues

Reputation: 39

Check in Administration Tools\Services (or type services.msc in the console if you a service named SQL Server (SQLEXPRESS). If you do then it is installed.

From Visual Studio open Server Explorer (menu View\Server Explorer or CTRL + W, L). Right click Data Connections and choose Create New SQL Server Database. After that create tables and stuff...

If you want the Management Studio to manage the server you must download and install it from:

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Upvotes: 3

Matt Kemp
Matt Kemp

Reputation: 2920

If you've downloaded SQL from the Microsoft site, rename the file to a zip file and then you can extract the files inside to a folder, then choose that one when you "Browse for SQL server Installation Media"

SQLEXPRADV_x64_ENU.exe > SQLEXPRADV_x64_ENU.zip

7zip will open it (standard Windows zip doesn't work though)

Extract to something like C:\SQLInstallMedia

You will get folders like 1033_enu_lp, resources, x64 and a bunch of files.

Upvotes: 85

Related Questions