SqlSetup: Module does not support installed feature BIDS

[dsccommunity]

SqlSetup: Module does not support installed feature BIDS

[forensicsguy20012004]

Yeah, I found that out as well, early on but I have yet had the time to get around to re-coding. It would be great if someone with the time could pick this up.

[wsmelton]

Just a note on this one, that it seems this is more than just the features listed in this bug. So I tried to use this features list: SQLENGINE,SSMS,ADV_SSMS,SNAC_SDK,SDK,BC,Conn and Test-TargetResource is returning false, BUT the features are still installed.

I have not dug into the Get-TargetResource for xSqlServerSetup module, but quick check and it seems there a few issues:

• The features is a string instead of an array. Not sure what the reasoning behind not having this be an array to begin with was, instead of having to split it.
• Get-TargetResource does not seem to handle anything other than the SSMS options and the components. Anything else it never validates so always returns false, not sure but this may be the only thing needed to fix it (?).

[pmcevoy]

Likewise, it doesn't work for the parent feature parameter "TOOLS".

[johlju]

Only BIDS left to support. BC and CONN is supported. Changing title to reflect that.

[johlju]

Feature BIDS should only exist in SQL Server 2008 R2 for installing Business Intelligence Development Studio, and SQL Server 2012 for installing SQL Server Data Tools (SSDT).

[johlju]

Updating this issue with a suggestions from @ptoluganti in issue #653. @ptoluganti suggest the following code to detect BIDS.

# Check if BIDS in installed
$BIDSRegistryPath = "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$($sqlVersion)0\BIDS\\*"

$isBIDSInstalled = (Get-ItemProperty -Path $BIDSRegistryPath -ErrorAction SilentlyContinue)
if ($isBIDSInstalled)
{
	$features += 'BIDS,'
}
else
{
	"BIDS Not found"
}

After installation of BIDS the following registry keys exist.

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\110\BIDS
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\110\BIDS\Setup
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\110\BIDS\Setup\SQL_BIDS_Full
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\110\BIDS\Setup\SQL_BIDS_Full\1033

Registry Key:
FeatureList has value SQL_BIDS_Full=3 SQL_WarehouseDevWorkbench_FNS=3

[johlju]

Closing this as SQL Server 2008 R2 has reached end-of-life.