xSQLServer\xSqlServerSetup question RRS feed

  • Question

  • Hi guys!

    I'm beginning my path with DSC and I try to setup an sql server on a 2012R2 machine.

    The script is as follow:

    xSqlServerSetup 'MSSQLSERVER' 
                DependsOn = "[WindowsFeature]NET-Framework-Core"
                SourcePath = '\\ilqhfaatc1vw004\c$\sql'
                SetupCredential = $SetupCredential
                InstanceName = 'MSSQLSERVER'
                Features = 'SQLENGINE,FULLTEXT,RS,AS,IS'
                SQLSysAdminAccounts = 'fse_admin'

    and I get the following error which I cannot figure out for the life of me:


    PSDesiredStateConfiguration\Node : The term 'xSQLServer\xSqlServerSetup' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and t
    ry again.
    At C:\Users\310230221\Desktop\dscsql.ps1:4 char:1
    + Node ilqhfaatc1vw004 {
    + ~~~~
        + CategoryInfo          : ObjectNotFound: (xSQLServer\xSqlServerSetup:String) [PSDesiredStateConfiguration\node], ParentCon 
        + FullyQualifiedErrorId : CommandNotFoundException,PSDesiredStateConfiguration\node

    WARNING: The configuration 'dscsql' is loading one or more built-in resources without explicitly importing associated modules. Add Import-DscResource –ModuleName 'PSDesiredStateConfiguration' to your configuration to avoid this message.
    Errors occurred while processing configuration 'dscsql'.
    At C:\Windows\system32\WindowsPowerShell\v1.0\Modules\PSDesiredStateConfiguration\PSDesiredStateConfiguration.psm1:line:3705 char:5
    +     t <<<< hrow $ErrorRecord

    I know that the x's are expiremental but it seems that version 7 has it (which is the newest) and 6 too.

    Wasn't able to find anything on the internet on the issue.

    Monday, May 15, 2017 12:35 PM

All replies

  • You do not have the xSQlServer loaded.

    install-module xsqlserver

    You can review the Examples directory in the xSQLServer module for some general use ...


    • Proposed as answer by Hello_2018 Tuesday, May 16, 2017 8:24 AM
    Monday, May 15, 2017 1:19 PM
  • It's really weird since it shows up when I do get-dscresource..

    Super strange!

    Tuesday, May 16, 2017 5:44 AM