search

Sitecore / Habitat

Sitecore Modular Architecture Example
Other
411 stars 399 forks source link

SQL version check fails w/ remote server #455

Open nickwesselman opened 5 years ago

nickwesselman commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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

if any other solution to fix this.

Thanks!