SQLPS SQL Powershell module is corrupt. How to fix or reinstall?

Grossnickle, Brenda 40

Re: SQLPS SQL Powershell module is corrupt. How to fix or reinstall?

First, how is it installed? We have SQL 2016, SSMS 15.0.18330.0. Any ideas on how I can repair it or totally remove every trace of it and then reinstall (i have tried repair of SSMS and SQL and restarted the server).

I get the error either in PS or from SQL Server Agent.

SQL Server Agent

Job Step with Type = Powershell. Single line of script - $ExportID = 1

A job step received an error at line 1 in a PowerShell script. The corresponding line is 'import-module SQLPS'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'Value does not fall within the expected range. '. Process Exit Code -1

PS 5

Import-Module SQLPS -Verbose. Failed when trying to load SQLPS.PS1

Import-Module : Value does not fall within the expected range.
At line:1 char:1
+ Import-Module SQLPS -Verbose
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Import-Module], ArgumentException
    + FullyQualifiedErrorId : FormatXmlUpdateException,Microsoft.PowerShell.Commands.ImportModuleCommand

Seeya Xi-MSFT 16,461 Reputation points

2023-04-03T07:50:07.4366667+00:00

Hi @Grossnickle, Brenda,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya

1 answer

Seeya Xi-MSFT 16,461

Hi @Grossnickle, Brenda,

To fix a corrupt SQLPS module, you can try the following steps:

Uninstall the SQL Server PowerShell module using the following command:

Uninstall-Module -Name SQLPS -Force

Reinstall the SQL Server PowerShell module using the following command:

Install-Module -Name SqlServer

This will install the latest version of the SQL Server PowerShell module.

Best regards,

Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Grossnickle, Brenda 40 Reputation points

2023-04-03T13:25:24.9633333+00:00

I need to fix SQLPS, not uninstall SQLPS and then install SqlServer module

Grossnickle, Brenda 40

This is the response I recieved when trying to uninstall SQLPS and then install SQLPS (I do not want the newer SqlServer module, i need SQLPS. we have several hundred clients with their own sql servers. we cannot have one off configurations)

can you help me with what they mean? I was not above to uninstall sqlps and i was not able to install any module due to NuGet, so I replied Y to install Nuget and it failed. I tried

Get-PackageProvider -ListAvailable

and there was nothing listed.

SQLPS comes with SQL Server and it is in my PSModulePath. It is automatically invoked by SQL Server when a SQL Agent Job step with Type = Powershell is started.

PSModulePath

C:\Program Files (x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules\

PS C:\Users\e1042994> Uninstall-Module -Name SQLPS -Force
PackageManagement\Uninstall-Package : Unable to find module providers (PowerShellGet).
At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:2157 char:21
+ ...        $null = PackageManagement\Uninstall-Package @PSBoundParameters
+                    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (Microsoft.Power...ninstallPackage:UninstallPackage) [Uninstall-Package
   ], Exception
    + FullyQualifiedErrorId : UnknownProviders,Microsoft.PowerShell.PackageManagement.Cmdlets.UninstallPackage
=================================================================================================================================	
PS C:\Users\e1042994> Install-Module -Name SQLPS

NuGet provider is required to continue
PowerShellGet requires NuGet provider version '2.8.5.201' or newer to interact with NuGet-based repositories. The NuGet provider must be available in 'C:\Program
Files\PackageManagement\ProviderAssemblies' or 'C:\Users\e1042994\AppData\Local\PackageManagement\ProviderAssemblies'. You can also install the NuGet provider by running
 'Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force'. Do you want PowerShellGet to install and import the NuGet provider now?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"): y

=================================================================================================================================

[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"): y
PackageManagement\Install-PackageProvider : Unable to find repository with SourceLocation ''. Use Get-PSRepository to see all available repositories.
At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:7405 char:21
+ ...     $null = PackageManagement\Install-PackageProvider -Name $script:N ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (Microsoft.Power...PackageProvider:InstallPackageProvider) [Install-PackageProvider], Exception
    + FullyQualifiedErrorId : RegisterPackageSourceRequired,Microsoft.PowerShell.PackageManagement.Cmdlets.InstallPackageProvider

PackageManagement\Import-PackageProvider : No match was found for the specified search criteria and provider name 'NuGet'. Try 'Get-PackageProvider -ListAvailable' to
see if the provider exists on the system.
At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:7411 char:21
+ ...     $null = PackageManagement\Import-PackageProvider -Name $script:Nu ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidData: (NuGet:String) [Import-PackageProvider], Exception
    + FullyQualifiedErrorId : NoMatchFoundForCriteria,Microsoft.PowerShell.PackageManagement.Cmdlets.ImportPackageProvider

PackageManagement\Get-PackageProvider : Unable to find package provider 'NuGet'. It may not be imported yet. Try 'Get-PackageProvider -ListAvailable'.
At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:7415 char:30
+ ... tProvider = PackageManagement\Get-PackageProvider -Name $script:NuGet ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (Microsoft.Power...PackageProvider:GetPackageProvider) [Get-PackageProvider], Exception
    + FullyQualifiedErrorId : UnknownProviderFromActivatedList,Microsoft.PowerShell.PackageManagement.Cmdlets.GetPackageProvider

Install-Module : NuGet provider is required to interact with NuGet-based repositories. Please ensure that '2.8.5.201' or newer version of NuGet provider is installed.
At line:1 char:1
+ Install-Module -Name SQLPA
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Install-Module], InvalidOperationException
    + FullyQualifiedErrorId : CouldNotInstallNuGetProvider,Install-Module

Share via

SQLPS SQL Powershell module is corrupt. How to fix or reinstall?

1 answer