I see that ERA 2.0 has a prerequisite of SQL Server SQLPS PowerShell module. Does anyone know what specific version is required? I ask because when trying to register a single node, I receive the following error:
Operation Failed : Unable to import SQLPS module. Please make sure that SQLPS module is available to proceed with Dbserver VM registration.
I suspect that the version of SQLPS PowerShell module that we have installed on our SQL servers is too new.
Hi
Install SQL Server SQLPS PowerShell module
May I know what is the current version of the SQLPS PowerShell module?
Also could you please check if SQLPS module exist in the following path, where your sql server is installed? We prefer to have the SQLPS version that comes along with the SQL Server Installation.
D:\Microsoft SQL Serverx86\120\Tools\PowerShell\Modules\SQLPS\SQLPS.psd1
Thanks, Neel -
The SQL 2017 version of the powershell modules was installed however the local SQLPS that is installed with SQL Server (native to each version) was NOT uninstalled. Could this be a matter of adding this newer path for the 2017 versions to the PSModulePath environment variables for Powershell?
Hi
PS C:\Users\Administrator.PROD> $env:PSModulepathC:\Users\Administrator.PROD\Documents\WindowsPowerShell\Modules;C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;D:\Microsoft SQL Serverx86\120\Tools\PowerShell\Modules\
That is the PSModulePath output in my system. Please add D:\Microsoft SQL Serverx86\120\Tools\PowerShell\Modules to the environment variables
Once this is done, please make sure that "Import-Module SQLPS" the command completes successfully from PowerShell before beginning the DB server registration.
If still, this doesn’t help then please open a support case and I will help you to get this DB registered.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
