SQL Server – Installation/Upgrade – Extract package files

Background

Here I am struggling to install Microsoft SQL Server.

It just will not install.

And, stubborness is not bailing me out.

Take a look at the files

Googled till I bled.

One of things I was asked to do was to take a look at the installation package.

Artifacts

RTM

For the RTM, which is delivered as an ISO, we are able to do the following :-

  1. Mount ISO
  2. Extract using 7-Zip

Service Packs ( SP ) and Cumulative patch ( CU )

Service Packs ( SP ) and Cumulative patches ( CU ) are delivered as an executable.

To uncompress them, please use the executable file itself and pass along the -extract argument.

Command Line

Syntax

[package] -extract:[target-folder]

Sample

SQLServer2017-KB4466404-x64.exe -extract:extract

Output

extract.20190313.1108AM.PNG

SQL Server – Installation – DISM

Background

Trying to install Microsoft SQL Server, but ran into a familiar error.

Blockers

Microsoft SQL Server 2005 Setup

System Configuration Check

Images

IIS Feature Requirement

sqlServer.v2005.SystemConfigurationCheck.20190308.0558PM.PNG

ASP.Net Version Registration Requirement

sqlServer.v2005.SystemConfigurationCheck.ASPNetRegistration.20190308.0603PM.PNG

Prerequisite

Installation

DISM

Outline

  1. Get
    • dism /online /get-features
    • dism /online /get-featureinfo
  2. Enable Feature
    • Dism /online /Enable-Feature

Tasks

get-features
Syntax

dism /online /get-features 

Sample

dism /online /get-features | find /i "IIS-ASPNET" 

Output

Feature Name : IIS-ASPNET
Feature Name : IIS-ASPNET45

get-featureinfo
Syntax

dism /online /get-featureinfo 

Sample

dism /online /get-featureinfo /featurename:NetFx3

Output

Deployment Image Servicing and Management tool
Version: 10.0.14393.0

Image Version: 10.0.14393.2457

Feature Information:

Feature Name : NetFx3
Display Name : .NET Framework 3.5 (includes .NET 2.0 and 3.0)
Description : .NET Framework 3.5 (includes .NET 2.0 and 3.0)
Restart Required : Possible
State : Enabled

Custom Properties:

FWLink : http://go.microsoft.com/fwlink/?LinkId=296822

The operation completed successfully.
get-featureinfo
Syntax

Dism /online /Enable-Feature /FeatureName:(feature-name) 

Sample

Dism /online /Enable-Feature /FeatureName:NetFx3 /All

Output

Deployment Image Servicing and Management tool
Version: 10.0.14393.0

Image Version: 10.0.14393.2457

Enabling feature(s)
[==========================100.0%==========================]
The operation completed successfully.

Actual

Here is what we need to do to enable IIS Web Server and the specific features required by SQL Server Engine and Reporting Services.

Enable IIS-Web Server
Code

DISM /Online /Enable-Feature /FeatureName:IIS-WebServer /all
DISM /Online /Enable-Feature /FeatureName:IIS-WebServerManagementTools /all
DISM /Online /Enable-Feature /FeatureName:IIS-WebServerRole /all

Enable IIS-Features
Code

DISM /Online /Enable-Feature /FeatureName:IIS-StaticContent /all
DISM /Online /Enable-Feature /FeatureName:IIS-DefaultDocument /all
DISM /Online /Enable-Feature /FeatureName:IIS-HttpRedirect /all
DISM /Online /Enable-Feature /FeatureName:IIS-DirectoryBrowsing /all

DISM /Online /Enable-Feature /FeatureName:IIS-ASP /all
DISM /Online /Enable-Feature /FeatureName:IIS-ASPNET /all

DISM /Online /Enable-Feature /FeatureName:IIS-ISAPIExtensions /all
DISM /Online /Enable-Feature /FeatureName:IIS-ISAPIFilter /all

DISM /Online /Enable-Feature /FeatureName:IIS-WindowsAuthentication /all

DISM /Online /Enable-Feature /FeatureName:IIS-Metabase /all

DISM /Online /Enable-Feature /FeatureName:IIS-WMICompatibility /all

SQL Server – v2019 – OS Requirements

Background

We are 3 months into 2019, and it is way past time to start evaluating SQL Server v2019.

Product Development Cycle

In terms of community participation, the product engagement cycle is :-

  1. Community Technology Preview ( CTP )
  2. Release Candidate
  3. Release To Manufacturing
  4. Cumulative Updates

Within each of this cycle, there will be tiered releases.

For instance :-

  1. Community Technology Preview ( CTP )
    • CTP 1
    • CTP 2
    • CTP 3
  2. Release Candidate
    • RC 1
    • RC 2
  3. Release To Manufacturing
    • RTM
  4. Cumulative Updates
    • CU 1
    • CU 2
    • CU 3
    • CU [n]

 

Where are we ?

As of today, we are at “SQL Server 2019 CTP 2.3 Evaluation Edition”.

 

Requirements

Blocking issue

Will love to download, install, and start playing and planning along.

But, for this issue :-

evaluationedition.20190304.0515PM.PNG

My OS is MS Windows 2012, but I need to be on at least MS Windows 2016.

Official

Link

hardwareANDsoftwareRequirements.20190304.0635PM

 

SSMS – v2008 – Error – “Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)”

Background

Drew a quick error running Sql Server Management Studio (SSMS).

Error

Text

The error reads :-

Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)

Image

SSSM.v2008.IndexWasOutsideTheBoundsOfTheArray.20190203.0652AM.PNG

Explanation

  1. Error reads
    • Microsoft.SqlServer.Smo
    • Index was outside the bounds of the array

Recreate

Tried connecting to Microsoft SQL Server v2017 instance with Sql Server Management Studio v2008.

 

TroubleShooting

Microsoft.SqlServer.Smo

SysInternals / Process Explorer

Version

Outline
  1. Download SysInternals \ Process Explorer
  2. Launched SysInternal’s Process Explorer
  3. Selected the ssms.exe
  4. View process modules
    • Click on menu “View”\”Show Lower Pane”
  5. Find
    • Click on menu and choose Find
    • Enter smo
    • Reviewed found modules
  6. Launched Windows Explorer
  7. Accessed the found DLL
  8. Noted version number as 10.0.1600.22
Images
Image – Process Explorer

processExplore.20190203.0957AM.PNG

Image – Handle or DLL substring

findModule.smo.PNG

Windows Explorer

ssmo.sysInternals.processExplorer.20190203.0720AM.PNG

Remediation

Microsoft SQL Server 2008 Service Pack 4 Feature Pack

SQL Server SMO is bundled as part of SQL Server Feature Pack.

The latest version is Service Pack 4 and it is available here.

Packages

  1. Shared Management Objects
    • ENU\X86\SharedManagementObjects.msi
  2. Clr Types
    • ENU\X86\SQLSysClrTypes.msi

Outline

  1. Download
    • Download ENU\X86\SharedManagementObjects.msi
    • Download ENU\X86\SQLSysClrTypes.msi
  2. Install
    • Install SQLSysClrTypes.msi
    • Install SharedManagementObjects.msi

Screenshot

Download

SQL System CLR Types

clrtypes.20190203.0732AM.PNG

Management Objects

microsoft.smo.20190203.0728AM.PNG

Installation

Management Objects
Prerequisite – Missing Microsoft SQL Server 2008 System CLR Types

clrtypes.20190203.0730AM.PNG

Welcome

microsoft.smo.welcome.20190203.0733AM.PNG

System CLR Types
Installation – SQL Server 2008 System CLR Types

clrtypes.welcome.20190203.0732AM.PNG

Post Installation Review

Outline

  1. Post Installation
    • Microsoft.SqlServer.Smo.dll
    • Version
      • Moved from 10.0.1600.22 to 10.0.6000.29

Images

WindowsExplorer.Microsoft.SqlServer.smo.dll.20190203.1028AM.PNG

Acknowledged

Acknowledged Giles D Middleton.

GilesDMiddleton.20190203.1041AM

 

References

  1. stack overflow
    • Index was outside the bounds of the Array. (Microsoft.SqlServer.smo)
      Link
  2.  Microsoft
    • Microsoft SQL Server 2008 Service Pack 4 Feature Pack
      Link

 

SQL Server / Minimum OS Software Requirement

Background

Wanted to tabulate the minimum MS Windows OS Requirement for the various versions of MS SQL Server.

 

Minimum OS Support Matrix

SQL Server Version OS Version – Server OS Version – Desktop Bitness Link
v2017  Windows Server 2012  Windows 8 Minimum: x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or fasterDoes not support 32 bit OS
 Link
v2016  Windows Server 2012  Windows 8 Minimum: x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or fasterDoes not support 32 bit OS
 Link
v2014  Windows Server 2008  Windows 7  x64 Processor
x86 Processor
 Link
v2012  Windows Server 2008  Windows Vista x86 Processor: 1.0 GHz
x64 Processor: 1.4 GHz
 Link
v2008-R2  Windows Server 2003 Windows Vista
Windows XP
x64 Processor
x86 Processor
 Link
v2008  Windows Server 2003 Windows Vista
Windows XP
x64 Processor
x86 Processor
 Link
 v2005  Windows Server 2000  Windows Vista
Windows XP
600-megahertz (MHz) Pentium III-compatible or faster processor
1-gigahertz (GHz) or faster processor recommended
 Link

 Link

 v2000  Windows NT Server 4.0  Windows 98
Link
 

 

 

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.

SQL Server Versions / OS Requirements

Background

Still caught in the throng of upgrading MS SQL Server instances to the latest supported by individual applications.

But, in all honesty the holding cell is more likely the age of the machine, bitness (32 or 64 bit),  and the underlying OS.

OS Requirements Matrix

SQL Server Version OS Version – Server OS Version – Desktop Link
MS Windows
SQL 2016 Windows 2012, Windows 2016 Windows 8, Windows 10  Link
SQL 2014 Windows 2016, Windows 2012/R2, Windows 2012, Windows 2008/R2, Windows 2008 Windows 8, Windows 7  Link
SQL 2012 Windows 2012, Windows 2008/R2 Windows 8, Windows 7,
Windows Vista
 Link
SQL 2008-R2  Windows 2012, Windows 2008/R2, Windows 2008, Windows  2003  Windows 7, Windows Vista  Link
SQL 2008 Windows 2012, Windows 2008/R2, Windows 2008, Windows  2003  Windows XP, Windows Vista, Windows 7  Link
SQL 2005  Windows 2003, Window 2000  Windows XP  Link

 

References

  1. Microsoft
    • Docs / SQL / SQL Server / Install
      • Hardware and Software Requirements for Installing SQL Server
        • SQL Server v2016
          Link
        • SQL Server v2014
          Link
        • SQL Server v2012
          Link
        • SQL Server v2008-R2
          Link
        • SQL Server v2008
          Link
  2. Pearson
    • Inform IT
      • v2005
        • SQL Server Robert Beatty, SQL Server 2005 Setup and Deployment
          Link