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.
@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.
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?
@mandg please add the newer path to the PSModulePath environment variable. When you type $eve:PSModulepath, you will get an output similar to this
That is the PSModulePath output in my system. Please add
D:\Microsoft SQL Serverx86\120\Tools\PowerShell\Modulesto 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.