Forum Discussion
SqlServer PS module and SQLPS Clarification
I've already started a thread last week about this on the SQL MSDN forums and have not gotten anywhere. So I'm hoping that since this might be more of PS thing, maybe you fine folks could shed some l...
matteo_taveggia
Microsoft
MicrosoftSQLPS and SQLServer are two indepndent modules.
SQLPS is the (legacy) module used by SQL Agent when running Job Steps that use the PowerShell subsytem (well, unless one uses the #NOSQLPS).
So, to answer your questions:
- No, it is not advised to uninstall SQLPS module (you would break SQL Agent)
- Yes, just use the -AllowClobber when installing SQLServer
- Do not (try to) Remove-Module SQLPS
SQLPS is the (legacy) module used by SQL Agent when running Job Steps that use the PowerShell subsytem (well, unless one uses the #NOSQLPS).
So, to answer your questions:
- No, it is not advised to uninstall SQLPS module (you would break SQL Agent)
- Yes, just use the -AllowClobber when installing SQLServer
- Do not (try to) Remove-Module SQLPS