Menu
Yes it is totally safe to delete it, this would not affect running SQL Server application. But sometimes during un-installation later or may be future installation or adding feature you may need the whole installation file.
Run the exe-installer that you downloaded when you installed for the very first time. Then select "Custom" installation type, and then it will appear your "Media location" path (e.g.: "C:\SQL2019"). Inside that path, is the valid instance folder (e.g. "C:\SQL2019\ExpressAdv_ENU").
The default database file location for server instances depends on the version of the Microsoft SQL Server software: SQL Server 2014 — C:\Program Files\Microsoft SQL Server\MSSQL12. MSSQLSERVER\MSSQL\DATA\ SQL Server 2016 — C:\Program Files\Microsoft SQL Server\MSSQL13.
Insert the SQL Server installation media. From the root folder, double-click Setup.exe. To install from a network share, locate the root folder on the share, and then double-click Setup.exe. The Installation Wizard runs the SQL Server Installation Center.
For the SQL Server 2017 (Developer Edition) installation, I did the following:
SQL Server Installation Center
Installation
New SQL Server stand-alone installation or add features to an existing installation
C:\SQLServer2017Media\Developer_ENU and click OK
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.
If you are using an executable,
Save yourself the hastle of renaming and unzipping etc.!
For the SQL Server 2019 (Express Edition) installation, I did the following:
SQL Server Installation Center
Installation New SQL Server stand-alone installation or add features to
an existing installation
C:\SQL2019\Express_ENU and click OK
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
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
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)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With