AutoSPInstaller for Single stand alone Server Installation

Topics: General Questions, Support
Nov 25, 2013 at 3:47 PM
Edited Nov 25, 2013 at 3:48 PM
we trying to install autospinstaller on a single server where SharePoint install will automatically install the SQL express edition behind the screen
it does install sharepoint, prerequisites, binaries and public updates successfully where SQL native client is installed as part of it when it comes to creating the config database the following error is throwed as mentioned below


I even changed the entry <Setting Id="SERVERROLE" Value="SINGLESERVER"/>in Config File

Based on the below error I understand is the SQL for SharePoint is not configured properly
  • Loading SharePoint Powershell Snapin...
    the local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
  • Checking farm membership for VM-6C22-55DC in "DevCloud13_Config"...
  • Attempting to join farm on "DevCloud13_Config"...
  • No existing farm found.
  • Creating config database "DevCloud13_Config"...
    ew-SPConfigurationDatabase : Cannot connect to database master at SQL server at vm-6c22-55dc. The database might not
    xist, or the current user does not have permission to connect to it.
    t D:\SP\AutoSPInstaller\AutoSPInstallerFunctions.ps1:1562 char:13
         New-SPConfigurationDatabase -DatabaseName "$configDB" -DatabaseServe ...
  • CategoryInfo : InvalidData: (Microsoft.Share...urationDatabase:SPCmdletNewSPConfigurationDatabase) [New
    -SPConfigurationDatabase], SPException
  • FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletNewSPConfigurationDatabase
Coordinator
Nov 25, 2013 at 3:55 PM
First, AutoSPInstaller doesn't support a single-server install, and second, it's nearly always a bad idea. Just install yourself a Dev or Trial edition of SQL server at minimum, but stay away from the single-server Express installs.

Brian
Nov 25, 2013 at 4:02 PM
Thanks for your prompt response, when you say "second, it's nearly always a bad idea" what does it mean ? if we have SQL Installed in the box then can Auto installer support single server installation ?

Thanks for again for your valuable feedback...
Coordinator
Nov 25, 2013 at 4:48 PM
Yes, having a non-Express version of SQL on the same box is fine (e.g. for Dev), so yes - to be clear, AutoSPInstaller does support such a single-server install, just not the type that installs a non-scalable Express edition as you originally indicated.

Cheers
Brian
Nov 25, 2013 at 8:57 PM
Brian thanks a ton for your feedback,

with this entry in config.xml, <Setting Id="SERVERROLE" Value="SINGLESERVER"/>, SharePoint should automatically install SQL express, this is native SharePoint functionality right when you install it manually

In the config-AutoSPInstaller.XML which is generated by Autospinstaller if we have this entry <Setting Id="SERVERROLE" Value="SINGLESERVER"/> doesn't that make SharePoint understand that it should install SQL express. is AutoSpInstall Overwriting this functionality anywhere ?


Can we make autospinstaller script point to config.xml which is in SharePoint binaries folder than point config-AutoSPInstaller ?
Coordinator
Dec 28, 2013 at 10:45 PM
I can't really say - AutoSPInstaller was never really designed for this, and even Microsoft would probably advise against this anyhow.

Brian