Sitecore Asked by aklein on February 7, 2021
Have a question about Sitecore 9.1 installation.
I have to create the installation manually without an outgoing internet connection. This means that I have to install also all prerequisites for databases mssql msi etc. After installing all listed things in the installation the webdeploy throws errors below.
My question is which dependencies I need to download and install (and from where) to run the script successfully:
"ERROR_SMO_NEEDED_FOR_SQL_PROVIDER" like '[WebDeploy]:[Path] C:Program FilesiisMicrosoft Web Deploy V3msdeploy.exe Info: Adding sitemanifest (sitemanifest). msdeploy.exe : Error Code: ERROR_SMO_NEEDED_FOR_SQL_PROVIDER At C:Program FilesWindowsPowerShellModulesSitecoreInstallFramework2.0.0PublicTasksInvoke-CommandTask.ps1:31 char:13 + & $Path $Arguments | Out-Default + ~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (Error Code: ERR...OR_SQL_PROVIDER:String) , RemoteException + FullyQualifiedErrorId : NativeCommandError More Information: The SQL provider cannot run because of a missing dependency. Please make sure that Microsoft SQL Server Management Objects (Version 10 or higher) is installed. Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_SMO_NEEDED _FOR_SQL_PROVIDER. Error count: 1. Install-SitecoreConfiguration : Command C:Program FilesiisMicrosoft Web Deploy V3msdeploy.exe returned a non-zero exit code - (-1) At D:script-packagesInstall91InstallationXM1-CM.ps1:90 char:2 + Install-SitecoreConfiguration @cmParams *>&1 | Tee-Object XM1-CM.log + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Install-SitecoreConfiguration [TIME] 00:01:00 Invoke-CommandTask : Command C:Program FilesiisMicrosoft Web Deploy V3msdeploy.exe returned a non-zero exit code - (-1) At C:Program FilesWindowsPowerShellModulesSitecoreInstallFramework2.0.0PublicTasksInvoke-WebDeployTask.ps1:36 char:2 + Invoke-CommandTask -Path $Path -Arguments $msdeployArgs -TaskName ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Invoke-CommandTask'
Just in case it may help someone - I just went past this issue, after spending the good part of the afternoon on it, by realizing that I had to install the package on the Sitecore server, and not on the database server.
I found everything I needed (and much more) in the SQL Server Feature Pack 2016 download page: https://www.microsoft.com/en-us/download/confirmation.aspx?id=52676
Answered by Emanuele Ciriachi on February 7, 2021
SQL Shared Management Objects (SMO) was not found or the installed version is too old.. The suggested resolution by Microsoft is to download SMO using Web Platform Installer. But since you don't have access to the Internet on the server, you'll have to download the offline version.
You can find SMO included in the SQL Server 2016 Feature Pack: https://www.microsoft.com/en-us/download/details.aspx?id=52676
Answered by TamerM on February 7, 2021
1 Asked on October 20, 2020 by sumitk
0 Asked on October 18, 2020 by katlego-masanabo
1 Asked on September 26, 2020 by meenu-chauhan
2 Asked on September 25, 2020
0 Asked on September 9, 2020 by eric-gonzalez
1 Asked on July 21, 2020 by himanshu-agarwal
Get help from others!
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP