AdfsFarmNode: SqlConnectionString and PrimaryComputerName/Port Should be Mutually Exclusive about adfsdsc

[CoreyLivingston]

Hi @X-Guardian - We're running into an issue and we were wondering if it's related this bug as well.

Here is some background info on our use case:

We are not using SQL with ADFS.
We are using chef to call these ADFS DSC modules.

Running the recipe the first time, everything works fine but converging a second time after ADFS has been installed/configured we get the following error:

Chef::PowerShell::CommandFailed
 -------------------------------
Unexpected exit in PowerShell command: ["PowerShell DSC resource MSFT_AdfsFarmNode  

failed to execute Set-TargetResource functionality with error message: System.InvalidOperationException: 
Unable to determine the SQL database state. 
An AD FS configuration database with the same name already exists; 
specify that the existing database is to be overwritten. "]

We were surprised to see that the module was attempting to validate the SQL DB state.

I can dig into this a bit further but was wondering if you think this is related.

Thanks

[X-Guardian]

Hi @CoreyLivingston, this would only be an issue if you were specifying both a SqlConnectionString and PrimaryComputerName/Port parameter in your Dsc Config.

The message you are seeing looks like output from the Get-AdfsSyncProperties cmdlet which the Get function of the AdfsFarmNode resource uses. I would need to see the Dsc verbose logs to help you further.

[CoreyLivingston]

Ah ok, thank you. I think our issue is different. I'll do a bit more research on my end.