A new Microsoft SQL repository has been create on rax.mirror.rackspace.com.
For SQL 2012-2022, it contains all the installation ISOs, Service Packs, Cumulative Updates, and SQL Server Management Studios.
Note: There is nothing in the timeline at this time as to when or if the current repository will be removed.
Repository: http://rax.mirror.rackspace.com/sql/
Product keys: https://passwordsafe.corp.rackspace.com/projects/31332
Notes:
- The SQL installation ISOs no longer have the product keys embedded in them. The keys can be obtained from the Product Keys link.
The key must be enter into the wizard during the installation process or the Evaluation Version will be installed.
- Since the ISOs do not contain keys, this means the new SQL repository is not in a protected area of rax.mirror.rackspace.com and credentials are not required to access it.
- Access to the SQL keys in PasswordSafe is granted via the following LDAP group:
cn Windows Bastion Users
description Access to WHAM powershell scripts and API only not bastions
- The single ISO for each version is use for all editions of that version. The product key used determines which edition gets installed.
- The Cumulative Update(CU) package does not contain the associated Service Pack(SP).
The associated Service Pack is a separate download. For example, to install Service Pack 2, Cumulative Update 7, for SQL 2016, you will need the following update files:
- sqlserver2016-sp2.exe
- sqlserver2016-sp2-cu7.exe
- Beginning with SQL 2017, Microsoft did away with Service Packs and went with Cumulative Updates only.
- If an older Service Pack or Cumulative update is missing from the repository, Microsoft has removed it from distribution.
- After SQL 2014(v12), SQL Server Management Studio(SSMS) is a separate download and install.
- SQL product descriptions and product versions are not the same. For example, SQL 2019(product description) is v15(product version).
The same is true for SQL Server Management Studio(SSMS). For example, for product description SSMS 18, the product version is v15.
With that said, an attempt will be made to keep the latest SSMS production version for the associated SQL product version in the repository.
- SQL 2016: ssms-setup-enu-p16-v13.exe = Product Description v16.5.3, Product Version v13
- SQL 2017: ssms-setup-enu-p17-v14.exe = Product Description v17.9.1, Product Version v14
- SQL 2019: ssms-setup-enu-p18-v15.exe = Product Description v18.12.1, Product Version v15
- SQL 2022: ssms-setup-enu-p19-v19.exe = Product Description v19.0.2, Product Version v19
- Starting with SQL 2019, Reporting Services is a separate download and install.
Current structure:
├── iso_prep
│ └── Microsoft executable that can be used to script the removal of keys from ISOs
├── sqlcmd
│ └── Components to installs SQL command line utility
├── sql_server_2012
│ ├── iso
│ │ └── sql2012_x64_enu_alleditions_nokey.iso
│ └── spcu
│ └── SQL 2012 Service Packs and Cumulative updates
├── sql_server_2014
│ ├── iso
│ │ └── sql2014_x64_enu_alleditions_nokey.iso
│ └── spcu
│ └── SQL 2014 Service Packs and Cumulative updates
├── sql_server_2016
│ ├── iso
│ │ └── sql2016_x64_enu_alleditions_nokey.iso
│ └── spcu
│ └── SQL 2016 Service Packs and Cumulative updates
├── sql_server_2017
│ ├── iso
│ │ └── sql2017_x64_enu_alleditions_nokey.iso
│ └── spcu
│ └── rtm
│ └── SQL 2017 Cumulative updates
├── sql_server_2019
│ ├── iso
│ │ └── sql2019_x64_enu_alleditions_nokey.iso
│ ├── reporting_services
│ │ └── sqlserverreportingservices.exe
│ └── spcu
│ └── rtm
│ └── SQL 2019 Cumulative updates
├── sql_server_2022
│ ├── iso
│ │ └── sql2022_x64_enu_alleditions_nokey.iso
│ ├── reporting_services
│ │ └── sqlserverreportingservices.exe
│ └── spcu
│ └── rtm
│ └── SQL 2022 Cumulative updates
└── ssms
└── SQL Server Management Studios