SQL version check fails w/ remote server

[nickwesselman]

Even though SIF supports a network SQL server, the version check in the Habitat install script results in the following error:

Could not find SQL Server 'devserver3', check settings.ps1
At C:\projects\habitat\install-xp0.ps1:44 char:9
+         throw "Could not find SQL Server '$SqlServer', check settings ...
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (Could not find ...ck settings.ps1:String) [], RuntimeException
    + FullyQualifiedErrorId : Could not find SQL Server 'devserver3', check settings.ps1

[MortazaKamalNourestani]

this is not an issue. install SSMS and run install-module sqlserver in PowerShell or try the script below.

PS D:> Install-Module -Name SqlServer

PS D:> Update-Module -Name SqlServer

PS D:> Get-Module SqlServer -ListAvailable

[jeanfrancoislarente]

Thanks for helping out @MortazaKamalNourestani

I think what you're saying is that it is possible that the SqlServer PowerShell module isn't "latest". I've noticed some "SIF" issues when SQL Server module isn't updated the way you have described.
This is specific to a remote SQL Server.

[MortazaKamalNourestani]

I am talking about installing Habitat on Remote SQL and I just did it on my PC. I was also getting the error above but after some research it turns out i had to do the steps below.

When you install SQL Server locally then Modules and everything else is there and that is why it works.

But, in order to be able to install Habitat on Remote SQL then you would need to install SQL Server Management Studio (SSMS) and SqlServer PowerShell Module on your developer PC where.

Also, make sure that you can connect to SQL Server using SSMS because something is telling me that SQL Server devserver3 is not reachable looking at this error "FullyQualifiedErrorId : Could not find SQL Server 'devserver3', check settings.ps1"

[prem16]

I am facing the same error,after trying the " install-module sqlserver in PowerShell "

Could not find SQL Server 'mafil', check settings.ps1
At D:\Download\Sitecore\Habitat\Habitat-1.6\Habitat-1.6\habitainstall.ps1:44 char:9

•     throw "Could not find SQL Server '$SqlServer', check settings ...
  

•     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : OperationStopped: (Could not find ...ck settings.ps1:String) [], RuntimeException
  • FullyQualifiedErrorId : Could not find SQL Server 'mafil', check settings.ps1

if any other solution to fix this.

Thanks!