search

dsccommunity / SqlServerDsc

This module contains DSC resources for deployment and configuration of Microsoft SQL Server.
MIT License
358 stars 224 forks source link

Default SourcePath Error #5

Closed tanwarsatya closed 9 years ago

tanwarsatya commented 9 years ago

I am trying to install SQL 2014 with xSQLServerSetup resource, node configuration is given below.

Node $AllNodes.Where{$_.InstallType -eq "SingleServer" }.NodeName
{
    $SecureSvcPassword = ConvertTo-SecureString -String $Node.SQLSvcAccountPassword -AsPlainText -Force
    xSQLServerSetup DefaultSQLInstance
    {
        InstanceName = $Node.SQLInstanceName
        SourcePath = "C:\BizTalk\SqlServer\"
        SecurityMode = "Windows"
        SetupCredential = $InstallCredential
        Features = $Node.SQLFeatures
        InstallSharedDir = "C:\Program Files\Microsoft SQL Server"
        InstallSharedWOWDir = "C:\Program Files (x86)\Microsoft SQL Server"
        SQLSvcAccount = New-Object System.Management.Automation.PSCredential($Node.SQLSvcAccount,$SecureSvcPassword)
    }

on Execution its by default looking for a directory 'SQLServer2012.en \ setup.exe' under the specified source. Not sure but i believe it should be looking setup.exe under the supplied source.

tanwarsatya commented 9 years ago

my mistake didn't look for the sourcefolder.