SQL Server 2017 – Developer Edition – ISO

Background

Currently, I have SQL Server 2014 Developer Edition on my laptop.

Recently found out that since my machine is now Windows 10, I can have SQL Server 2017 Developer Edition.

 

Download ISO

Let us go download v2017 Developer Edition.

v2017 is available here.

Available

Image

Textual

  1. Free Trial Evaluation
  2. Developer edition
  3. Express edition

Developer Edition

If we click on the “Download now” button underneath the “Developer edition“, we will notice that the name of the file that will be availed is SQLServer2017-SSEI-Dev.exe.

Already have that file and it is a small file.

I don’t really want a small file, I want the full ISO.

 

Self-Prepare ISO

Download Bootstrap

To get a nice ISO, please process with downloading SQLServer2017-SSEI-Dev.exe.

 

Prepare ISO

Outline

  1. Select an installation type
  2. Specify SQL Server Installer download
    • Which package will you like to download
      • ISO
      • CAB
    • Click on the Browser folder button
      • Choose an existing folder or create a new folder
      • Click the OK button
    • Click the OK button
  3. Download Media

Screen shot

Select an Installation Type

 

Specify SQL Server Installer download

Browse Folder

Download Media

Download Successful

 

Installed

Once the files was packaged into a nice ISO, was able to install it.

 

Conclusion

So unfortunately, it appears that one cannot download v2017 as a nice offline ISO.

But, please do not let that overly deter you.

Go ahead and download SQLServer2017-SSEI-Dev.exe and run it.

You will be able to prepare an ISO through running that package.

“Remote Server Administration Tools” And OS Compatibility

Background

I have a new machine that has MS Windows 10 on it and it giving my a lot of headache.

Active Directory Users and Computer

This morning I realized that I need “Microsoft Active Directory Users and Computers“.

As I did not see it, I said I need to go ahead and install it.

 

Remote Server Administration Tools

Active Directory Users and Computer is a MMC ( Microsoft management Console ) that is bundled within “Remote Server Administration Tools“.

 

Remote Server Administration Tools for Windows 7 with Service Pack 1 (SP1)

Download

Googled for “Active Directory Users and Computers” and landed here.

Downloaded both x64 ( Windows6.1-KB958830-x64-RefreshPkg.msu ) bit and 32 ( Windows6.1-KB958830-x86-RefreshPkg.msu ) bit.

Install

Error

Textual

Windows Update Standalone Installer

Installer encountered an error: 0x80096002

The certificate for the signer of the message is invalid or not found

 

 

Remote Server Administration Tools for Windows 10

Download

Googled for “Active Directory Users and Computers” for Windows 10 and landed here.

Here is what is available:

OS Bitness Filename
Windows 10
x64 WindowsTH-RSAT_WS_1709-x64.msu
x32 WindowsTH-RSAT_WS_1709-x86.msu
Windows ( Previous version of Windows )
x64 WindowsTH-RSAT_WS2016-x64.msu
x32 WindowsTH-RSAT_WS2016-x86.msu

 

Running Windows 10, and not previous Windows Version, downloaded the x64  Version for Windows 10 ( WindowsTH-RSAT_WS_1709-x64.msu ).

Installed

As I have a 64-bit OS, launched the 64-bit installer.

Restart Machine

Please restart your machine.

 

Summary

There is likely consensus that an error message that reads “The certificate for the signer of the message is invalid or not found” could mean so many things.

For instance:

  1. The Vendor’s certificate is compromised and thus the certificate has been pulled

Thankfully in this case it simply means the binary targets a particular OS.  And, that OS is not this one.

And, so look to see if you can find a binary that targets your specific OS.

Windows 10 – Create Installation Media Using “Media Creation Tool”

Background

Wifey’s Windows 10 HP Stream Laptop is no longer accessible; nothing major but she can not remember what she changed the password to.

 

Diagnosis

A lot of tools for trying to get back in relies on using a Windows Installer, Linux Boot CD, or various third party tools.

I was able to start the laptop up with Windows 7 and Windows 2008-R2, but none of them picked up the internal hard-disk.

Seemingly, MSFT has secured the hard-drive more since these OSes.

 

Resolution

It is time to try out Windows 10 Installer.

Download

Please download Media Creation Tool from here.

Prepare

Once Media Creation Tool is downloaded, please launch it.

Steps

  1. License Terms
  2. What do you want to do
    • Choices
      • Upgrade this PC now
      • Create installation media  ( USB Flash drive, DVD, or ISO File ) for another PC
    • As we preparing an Installation Media for another PC, chose the second option, “Create installation media
  3. Select Language, and Edition, and Architecture
    • Language – English ( United States )
    • Edition – Windows 10
    • Architecture ( 32 bit, 64 bit, or both )
  4. 4 / 8 GB of free disk space needed on Drive C:
    • Depending on the Architecture Choice made earlier, that is 32 bit, 64 bit, or both, specific disk space requirement on the System Drive will have to be met
    • If either or, 32 or 64 bit is desired, 4 GB will be needed
    • On the other hand, if both bitness is desired, 8 GB will be needed
  5. Processing
    • Files are downloaded from MSFT
    • The image is cached locally
  6. Availed
    • Image is availed locally on the designated folder

Image

License Terms

LicenseTerms_20171122_0105AM

What do you want to do ?

WhatDoYouWantToDo_20171122_0106AM

 

Select language, architecture, and edition

SelectLanguageArchitectureAndEdition_20171122_0107AM

 

 

4GB/8 GB of free disk space needed on (C : )

DiskSpaceRequirement_20171122_0110PM

 

 

Burn the ISO file to a DVD

BurnTheISOFileToADVD_20171122_0236AM