#sql-server #docker #installation #windows-server-2016 #windows-container
Вопрос:
Прежде чем кто-либо предложит использовать контейнер на основе 2019 года, SQL Server 2017 и CU26 не будут устанавливаться в контейнер на основе 2019 года из-за того, что в контейнерах на основе 2019 года используется кодовая страница 65001, и ее нельзя изменить..
Использование этого файла docker
# escape=`
FROM mcr.microsoft.com/windows/servercore:ltsc2016
#
ADD https://github.com/microsoft/windows-container-tools/releases/download/v1.1/LogMonitor.exe LogMonitor.exe
#
SHELL ["powershell", "-Command", "$ErrorActionPreference = 'Stop'; $ProgressPreference = 'SilentlyContinue';"]
#
# Download and install Visual C Redistributable
#
ADD https://aka.ms/vs/16/release/vc_redist.x64.exe .
RUN Start-Process c:vc_redist.x64.exe -Wait -ArgumentList "/q"
RUN Remove-Item c:vc_redist.x64.exe
#
# Download and Install .NET Framework 4.8
#
ADD https://download.visualstudio.microsoft.com/download/pr/2d6bb6b2-226a-4baa-bdec-798822606ff1/8494001c276a4b96804cde7829c04d7f/ndp48-x86-x64-allos-enu.exe .
RUN c:ndp48-x86-x64-allos-enu.exe /q /norestart
RUN Remove-Item c:ndp48-x86-x64-allos-enu.exe
#
RUN New-Item -ItemType "directory" C:INSTALL
#
# Unpack SQL Server
#
WORKDIR c:/INSTALL
COPY SQLServer2017-DEV-x64-ENU.exe .
COPY SQLServer2017-DEV-x64-ENU.box .
RUN .SQLServer2017-DEV-x64-ENU.exe /x:SQLServer2017-DEV-x64-ENU /u
RUN Remove-Item SQLServer2017-DEV-x64-ENU.exe
RUN Remove-Item SQLServer2017-DEV-x64-ENU.box
#
# Unpload the Cummulative update #26: SQLServer2017-KB5005226-x64
#
RUN New-Item -ItemType "directory" CU
# ADD https://download.microsoft.com/download/C/4/F/C4F908C9-98ED-4E5F-88D5-7D6A5004AEBD/SQLServer2017-KB5005226-x64.exe CU/SQLServer2017-KB5005226-x64.exe
COPY SQLServer2017-KB5005226-x64.exe CU
#
# Install SQL Server Applying the Cummlative Update
#
COPY install.ps1 .
#RUN C:INSTALLSQLServer2017-DEV-x64-ENUSETUP.exe /Q /ACTION=Install /UPDATEENABLED=TRUE /UpdateSource="C:INSTALLCU" /FEATURES=SQLEngine /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT='NT AUTHORITYSystem' /SQLSYSADMINACCOUNTS='BUILTINADMINISTRATORS' /TCPENABLED=1 /NPENABLED=0 /IACCEPTSQLSERVERLICENSETERMS=1 /SECURITYMODE=SQL /SAPWD="oracle#1"
#
WORKDIR c:/
COPY prepareMounts.ps1 .
# RUN Set-Service -Name "MSSQLSERVER" -StartupType "Manual"; `
# Stop-Service -Name "MSSQLSERVER"; `
# c:prepareMounts.ps1; `
# Remove-Item c:prepareMounts.ps1
#
COPY Start.ps1 .
#ENTRYPOINT [ "powershell","c:\Start.ps1","-ACCEPT_EULA $ENV:ACCEPT_EULA","-SA_PASSWORD $ENV:SA_PASSWORD"]
#ENTRYPOINT powershell "c:\Start.ps1 -ACCEPT_EULA $ENV:ACCEPT_EULA -SA_PASSWORD $ENV:SA_PASSWORD
ENTRYPOINT ["powershell","wait-event"]
для установки SQL Server 2017 и CU26. Install.ps1 содержит ту же инструкцию, что и инструкция RUN, которая закомментирована в файле dockerfile.
Когда я запускаю контейнер и запускаю Install.ps1, система сообщает, что установка прошла успешно, что соответствует действительности, служба не была создана. Проверка журналов
PS C:Program FilesMicrosoft SQL Server140Setup BootstrapLog> type .Summary.txt
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068052413
Start time: 2021-10-15 16:11:11
End time: 2021-10-15 16:13:24
Requested action: Install
Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for SQLEngine: Use the following information to resolve the error, and then try the setup process again.
Machine Properties:
Machine name: E50414390E10
Machine processor count: 2
OS version: Microsoft Windows Server 2016 Datacenter - ServerCore (10.0.14393)
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
Package properties:
Description: Microsoft SQL Server 2017
ProductName: SQL Server 2017
Type: RTM
Version: 14
Installation location: C:INSTALLSQLServer2017-DEV-x64-ENUx64setup
Installation edition: Developer
Slipstream: True
SP Level 0
Patch Level: 14.0.3411.3
Product Update Status:
Success: KB 5005226
Product Updates Selected for Installation:
Title: Hotfix Pack
Knowledge Base Article: KB 5005226
Version: 14.0.3411.0
Architecture: x64
Language: All
Update Source: C:INSTALLCU
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT: NT ServiceSQLSERVERAGENT
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSERVERMODE: TABULAR
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: <empty>
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <empty>
ASTELSVCACCT: <empty>
ASTELSVCPASSWORD: <empty>
ASTELSVCSTARTUPTYPE: 0
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled
CLTCTLRNAME: <empty>
CLTRESULTDIR: <empty>
CLTSTARTUPTYPE: 0
CLTSVCACCOUNT: <empty>
CLTSVCPASSWORD: <empty>
CLTWORKINGDIR: <empty>
COMMFABRICENCRYPTION: 0
COMMFABRICNETWORKLEVEL: 0
COMMFABRICPORT: 0
CONFIGURATIONFILE: C:Program FilesMicrosoft SQL Server140Setup BootstrapLog20211015_161005ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: false
ENU: true
EXTSVCACCOUNT: <empty>
EXTSVCPASSWORD: <empty>
FEATURES: SQLENGINE
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
IACCEPTSQLSERVERLICENSETERMS: true
INDICATEPROGRESS: false
INSTALLSHAREDDIR: C:Program FilesMicrosoft SQL Server
INSTALLSHAREDWOWDIR: C:Program Files (x86)Microsoft SQL Server
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:Program FilesMicrosoft SQL Server
INSTANCEID: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISMASTERSVCACCOUNT: NT AUTHORITYNetwork Service
ISMASTERSVCPASSWORD: <empty>
ISMASTERSVCPORT: 8391
ISMASTERSVCSSLCERTCN: <empty>
ISMASTERSVCSTARTUPTYPE: Automatic
ISMASTERSVCTHUMBPRINT: <empty>
ISSVCACCOUNT: NT AUTHORITYNetwork Service
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
ISTELSVCACCT: <empty>
ISTELSVCPASSWORD: <empty>
ISTELSVCSTARTUPTYPE: 0
ISWORKERSVCACCOUNT: NT AUTHORITYNetwork Service
ISWORKERSVCCERT: <empty>
ISWORKERSVCMASTER: <empty>
ISWORKERSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
MRCACHEDIRECTORY:
NPENABLED: 0
PBDMSSVCACCOUNT: <empty>
PBDMSSVCPASSWORD: <empty>
PBDMSSVCSTARTUPTYPE: 0
PBENGSVCACCOUNT: <empty>
PBENGSVCPASSWORD: <empty>
PBENGSVCSTARTUPTYPE: 0
PBPORTRANGE: <empty>
PBSCALEOUT: false
PID: *****
QUIET: true
QUIETSIMPLE: false
ROLE:
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: SQL
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: NT AUTHORITYSystem
SQLSVCINSTANTFILEINIT: false
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: BUILTINADMINISTRATORS
SQLTELSVCACCT: NT ServiceSQLTELEMETRY
SQLTELSVCPASSWORD: <empty>
SQLTELSVCSTARTUPTYPE: Automatic
SQLTEMPDBDIR: <empty>
SQLTEMPDBFILECOUNT: 2
SQLTEMPDBFILEGROWTH: 64
SQLTEMPDBFILESIZE: 8
SQLTEMPDBLOGDIR: <empty>
SQLTEMPDBLOGFILEGROWTH: 64
SQLTEMPDBLOGFILESIZE: 8
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SUPPRESSPRIVACYSTATEMENTNOTICE: false
TCPENABLED: 1
UIMODE: Normal
UpdateEnabled: true
UpdateSource: C:INSTALLCU
USEMICROSOFTUPDATE: false
X86: false
Configuration file: C:Program FilesMicrosoft SQL Server140Setup BootstrapLog20211015_161005ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, and then try the setup process again.
Component name: SQL Server Filestream Driver
Component error code: 1603
Component log file: C:Program FilesMicrosoft SQL Server140Setup BootstrapLog20211015_161005RsFx_Cpu64_1_Local.log
Error description: Fatal error during installation.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476amp;ProdName=Microsoft SQL Serveramp;EvtSrc=setup.rllamp;EvtID=50000amp;ProdVer=14.0.3411.3amp;EvtType=RsFx.msi@0x162A16FE@0x1603
Feature: SQL Browser
Status: Passed
Feature: SQL Writer
Status: Passed
Feature: SQL Client Connectivity
Status: Passed
Feature: SQL Client Connectivity SDK
Status: Passed
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:Program FilesMicrosoft SQL Server140Setup BootstrapLog20211015_161005SystemConfigurationCheck_Report.htm
Looking at the file C:Program FilesMicrosoft SQL Server140Setup BootstrapLog20211015_161005RsFx_Cpu64_1_Local.log implies that the installation of the slipstreamed version of the RSFX Driver failed.
MSI (s) (A4:18) [16:13:13:222]: Doing action: ProcessComponents
Action ended 16:13:13: Sqlmsirc_NotifyFeatureStates_64. Return value 1.
MSI (s) (A4:18) [16:13:13:222]: Note: 1: 2205 2: 3: MsiPatchCertificate
MSI (s) (A4:18) [16:13:13:222]: LUA patching is disabled: missing MsiPatchCertificate table
MSI (s) (A4:18) [16:13:13:222]: Resolving source.
MSI (s) (A4:18) [16:13:13:222]: Resolving source to launched-from source.
MSI (s) (A4:18) [16:13:13:222]: Setting launched-from source as last-used.
MSI (s) (A4:18) [16:13:13:222]: PROPERTY CHANGE: Adding SourceDir property. Its value is 'C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup'.
MSI (s) (A4:18) [16:13:13:222]: PROPERTY CHANGE: Adding SOURCEDIR property. Its value is 'C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup'.
MSI (s) (A4:18) [16:13:13:222]: PROPERTY CHANGE: Adding SourcedirProduct property. Its value is '{904DD647-5CB8-4C5D-BB4A-D1E14E25E0F8}'.
MSI (s) (A4:18) [16:13:13:222]: SOURCEDIR ==> C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup
MSI (s) (A4:18) [16:13:13:222]: SOURCEDIR product ==> {904DD647-5CB8-4C5D-BB4A-D1E14E25E0F8}
MSI (s) (A4:18) [16:13:13:222]: SECREPAIR: CryptAcquireContext succeeded
MSI (s) (A4:18) [16:13:13:222]: Determining source type
MSI (s) (A4:18) [16:13:13:222]: Source type from package 'rsfx.msi': 2
MSI (s) (A4:18) [16:13:13:222]: SECREPAIR: Hash Database: C:WindowsInstallerSourceHash{904DD647-5CB8-4C5D-BB4A-D1E14E25E0F8}
MSI (s) (A4:18) [16:13:13:222]: Note: 1: 2262 2: SourceHash 3: -2147287038
MSI (s) (A4:18) [16:13:13:222]: SECREPAIR: New Hash Database creation complete.
MSI (s) (A4:18) [16:13:13:237]: Source path resolution complete. Dumping Directory table...
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: TARGETDIR , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: , ShortSubPath:
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: ProgramFiles64Folder , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: Program Files , ShortSubPath: PFiles
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: SqlShared_64 , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: Program FilesMicrosoft SQL Server , ShortSubPath: PFilesSqlServr
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: Ver_64 , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: Program FilesMicrosoft SQL Server140 , ShortSubPath: PFilesSqlServr140
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: SqlSharedKeyFile_64 , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: Program FilesMicrosoft SQL Server140KeyFile , ShortSubPath: PFilesSqlServr140KeyFile
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: SqlSharedKeyFileLoc_64_1033 , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: Program FilesMicrosoft SQL Server140KeyFile1033 , ShortSubPath: PFilesSqlServr140KeyFile1033
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: Shared_64 , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: Program FilesMicrosoft SQL Server140Shared , ShortSubPath: PFilesSqlServr140Shared
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: RsFxInstall_64 , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: Program FilesMicrosoft SQL Server140SharedRsFxInstall , ShortSubPath: PFilesSqlServr140SharedRsFxInst
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: WindowsFolder , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: Windows , ShortSubPath:
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: System64Folder , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: WindowsSystem32 , ShortSubPath:
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: SystemDir_64 , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: WindowsSystem32 , ShortSubPath:
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: System32_Drivers_64 , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: WindowsSystem32Drivers , ShortSubPath:
MSI (s) (A4:18) [16:13:13:237]: Dir (source): Key: System32_RsFx_64 , Object: C:Program FilesMicrosoft SQL Server140Setup BootstrapUpdate CacheKB5005226QFEx64setup , LongSubPath: WindowsSystem32RsFx , ShortSubPath:
Action start 16:13:13: ProcessComponents.
MSI (s) (A4:18) [16:13:13:331]: Doing action: UnpublishComponents
К вашему сведению, перейдя по предложенной ссылке https://go.microsoft.com/fwlink?LinkId=20476amp;ProdName=Microsoft SQL Serveramp;EvtSrc=setup.rllamp;EvtID=50000amp;ProdVer=14.0.3411.3amp;EvtType=RsFx.msi@0x162A16FE@0x1603 кажется, подразумевает, что я должен купить новую поверхность студии ноутбук, который немного иронично, учитывая, что я использую в 2-месячный поверхность Книга 3 🙂