xSqlPs PowerShell Module (DSC Resource Kit)

The xSqlPs module is a part of the Windows PowerShell Desired State Configuration (DSC) Resource Kit. This module contains the xSqlServerInstall, xSqlHAService, xSqlHAEndpoint, xSqlHAGroup, and xWaitForSqlHAGroup resources.

5 Star
8,785 times
Add to favorites
E-mail Twitter del.icio.us Digg Facebook
  • xSqlHAService resources throws OSQL is not recognized as cmdlet
    1 Posts | Last post December 03, 2014
    • I'm in process of building SQLFailover cluster using xSqlPS resource. however, when the control hits the xSqlHAService block, the execution fails with error message as "the term OSQL is not recognized as the name of a cmdlet". FYI, I tried explicitly adding the osql install path i.e., "c:\program files\Microsoft SQL Server\110\Tools\Binn" to env.path variable; but, still the issue persist on Windows Server 2012 R2. Any idea on how to get rid of this issue? Your response is much appreciated. Thanks!
  • Installs eval edition
    1 Posts | Last post October 10, 2014
    • The xSqlServerInstall resource will only install SQL in evaluation mode.  Can you modify to accept a PID parameter or, even better, an ini file for input?
  • What versions of SQL is this compatible with?
    1 Posts | Last post February 21, 2014
    • Is this resource only compatible with SQL 2012 or does it work with SQL 2008 as well?  Keep up the awesome work!