Question

ERA 2.0 requirements

  • 9 October 2020
  • 3 replies
  • 418 views

Userlevel 1
Badge +12

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. 


3 replies

Userlevel 3
Badge +4

Hi @mandg as per the ERA 2.0 Guide it says before you begin

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

 

 

Userlevel 1
Badge +12

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?

Userlevel 3
Badge +4

Hi @mandg  please add the newer path to the PSModulePath environment variable. When you type $eve:PSModulepath, you will get an output similar to this

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. 

Reply