missing sqlserver

[Joshivkoshi]

Hello, I need your help.
I was trying to run the script but I ran into this error message:

.\Optimize-WsusServer.ps1 : The script 'Optimize-WsusServer.ps1' cannot be run because the following modules that are s
pecified by the "#requires" statements of the script are missing: SqlServer.
At line:1 char:1

• .\Optimize-WsusServer.ps1

•   + CategoryInfo          : ResourceUnavailable: (Optimize-WsusServer.ps1:String) [], ScriptRequiresException
    + FullyQualifiedErrorId : ScriptRequiresMissingModules
  

When I check if I have sqlserver installed and ready it says yes, so Im now stuck.
Im begginer in this type of stuff so sorry if its easy to solve or even stupid to ask.

Thanks
Joshivkoshi

[amjelnes]

Do you have the powershell module "sqlserver" installed and imported?
It was the exact same error I experienced when running the script first time.
It should be fixed by running this in admin powershell:
Install-Module -Name SqlServer -RequiredVersion 21.1.18256 -Force -AllowClobber

The reason for the specific version of sqlserver module is that the newer versions of the module are missing the invoke-sqlcmd command.

[Joshivkoshi]

I do have required version of sqlserver. However I've somehow managed to run ".\Optimize-WsusServer.ps1" but it's been a month since then, so I dont remember how I've done it