SqlSetup: Trouble installing the feature RS_SHPWFE

[dsccommunity]

SqlSetup: Trouble installing the feature RS_SHPWFE

[olljanat]

Looks hat "Get-TargetResource" cmdlet is implemented the way that it only supports these features:

• SQLENGINE
• AS
• IS
• SSMS
• ADV_SSMS

You can use any combination of these features but these must be on that order.
Example:

• "SQLENGINE,ADV_SSMS"
• "AS,SSMS"

Other way test will fail and DSC will always try reinstall SQL.

Issue #3 is also connected to this one.

Right solution probably would be create "Get-TargetResource" function which supports all SQL features and these should be handled stored to sorted array which would fix all these issues.

Biggest issue is that detetion method is probably needed to implement for each feature differently.

Another option would be use discovery tool from installation media using command:discovery too
\setup.exe /ACTION=RUNDISCOVERY /QUIET
That stores HTML report of features to C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log

[abouman]

I am experiencing the same issue while trying to add the following features:
BIDS, CONN, BC (Business Intelligence Design Studio, Client Tools Connectivity, Backwards Compatibility).
I receive the following error, even though the features get installed, same as reported above:
"PowerShell DSC resource MSFT_xSQLServerSetup failed to execute Set-TargetResource functionality with error message: Set-TargetResouce failed"

I am running WMF5.0 on Windows Server 2012R2

Is there a plan to enhance the Set-TargetResource to support the additional features of SQL Server? Is there a suggested work-around?

I am currently using DSC to install SQL Server 2012, Enterprise Edition.

Another issue: In the xSQLServer module, the "Paths" location for database files, log files, TempDB files, and Backup files are included (SQLUserDBDir, SQLUserDBLogDir, SQLTempDBDir, etc), however they are not included for Full Text Data. In my installs, I typically place my Full Text files on a separate drive for performance. I am not able to do this with the module as currently written.
Is there a plan to correct this?

Thank you kindly in advance!
Angela Bouman

[rolflobker]

Also; looks like it is also failing on SSMS;

I only selected SQLEngine, SSMS as features to install.

The Get-TargetResource function contains;

$Products = Get-WmiObject -Class Win32_Product
switch($SQLVersion)
{
    "10"
    {
        $IdentifyingNumber = "{72AB7E6F-BC24-481E-8C45-1AB5B3DD795D}"
    }
    "11"
    {
        $IdentifyingNumber = "{A7037EB2-F953-4B12-B843-195F4D988DA1}"
    }
    "12"
    {
        $IdentifyingNumber = "{75A54138-3B98-4705-92E4-F619825B121F}"
    }
}

But it seems the SSMS feature for SQL 2014 Express is:

IdentifyingNumber : {839EF29A-3055-43DC-ADCE-8E84893798D5}
Name : SQL Server 2014 Management Studio
Vendor : Microsoft Corporation
Version : 12.1.4100.1
Caption : SQL Server 2014 Management Studio

[rolflobker]

Also, the install state for the features fails if they are not CAPITALIZED in the configuration;

This works: Features = "SQLENGINE,SSMS"
This fails : Features = "SQLEngine,SSMS"

[abouman]

Update: For the issue of no support for the following features:
BC, CONN, BIDS and REPLICATION, I have taken the xSQLServerSetup module and created a cSQLServerSetup custom module that allows for the support of these additional features.
Angela Bouman

[rodtobias]

Hi @abouman,
What did you do to get the BC, CONN, and BIDS working for the xSQLServerSetup module? I understand you created a cSQLServerSetup custom module that allows for the support of these additional features. Is it possible if I see this code as well? Do you have it posted anywhere? Thanks in advance.

[johlju]

xSQLServerSetup does not currently support RS_SHP or RS_SHPWFE shared features.
We should make sure to add these. They should also support the 'FilesOnly' support option.