Forum Discussion

goh1983's avatar
goh1983
Copper Contributor
Dec 13, 2023

how to install smo in an offline machine

hi,

 

how do I install smo in a offline machine

https://www.nuget.org/packages/Microsoft.SqlServer.SqlManagementObjects#usedby-body-tab

Install-Package Microsoft.SqlServer.SqlManagementObjects -Version 170.18.0

 

PS C:\Users\Administrator> Find-Module -Repository smo

 

Version Name Repository Description

------- ---- ---------- -----------

21.0.17224 SqlServer SMO This module allows SQL Server developers, admin

 

i could not find the package inside the folder packages even though the package is inside

microsoft.sqlserver.sqlmanagementobjects.161.44091.28.nupkg

 

it only show sqlserver package not the smo

2 Replies

    • goh1983's avatar
      goh1983
      Copper Contributor

      Javier_Villegas 

       

      hi,

       

      I tried . it does not work.

      it was throwing

       

      PS C:\Users\Administrator> Save-Module -Name Microsoft.SqlServer.SqlManagementObjects -RequiredVersion 170.18.0 -Repository nuget -Path C:\localrepo
      WARNING: Dependency loop detected for package 'Microsoft.SqlServer.SqlManagementObjects'.
      WARNING: Package 'Microsoft.SqlServer.SqlManagementObjects' failed to install.
      PackageManagement\Save-Package : Unable to save the module 'Microsoft.SqlServer.SqlManagementObjects'.
      At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:1598 char:21
      + $null = PackageManagement\Save-Package @PSBoundParameters
      + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      + CategoryInfo : InvalidOperation: (Microsoft.Power...ets.SavePackage:SavePackage) [Save-Package], Except
      ion
      + FullyQualifiedErrorId : ProviderFailToDownloadFile,Microsoft.PowerShell.PackageManagement.Cmdlets.SavePackage

      PS C:\Users\Administrator>

       

      any idea on how to solve this

       

      thank you

Resources