DSC Pull Server Reporting setup using MSAccess/SQL Server

I fond this article on using Power BI to create a reporting dashboard for DSC: https://blogs.technet.microsoft.com/fieldcoding/2017/05/21/visualize-dsc-reporting-with-powerbi/
I have been trying to implement this solution (even though I think it stinks as an Enterprise solution for this, but, that’s another thread :)). I have followed all the instructions as closely as possible, however, when I try to set client to PULL mode I get this error:

Registration of the Dsc Agent with the server https://:8080/PSDSCPullServer.svc failed. The
underlying error is: The attempt to register Dsc Agent with AgentId D5C98796-3CCE-11E7-80D4-005056A77AB8 with the
server https://:8080/PSDSCPullServer.svc/Nodes(AgentId=‘D5C98796-3CCE-11E7-80D4-005056A77AB8’)
returned unexpected response code InternalServerError. .
+ CategoryInfo : InvalidResult: (root/Microsoft/…gurationManager:String) [], CimException
+ FullyQualifiedErrorId : RegisterDscAgentUnsuccessful,Microsoft.PowerShell.DesiredStateConfiguration.Commands.Reg

If I switch the reporting back to using ESENT and the .edb file everything works fine.

Has anyone actually deployed this solution and made it work?

Turns out it was me being an idiot :slight_smile:

I didn’t have the ‘dbconnectionstr’ path correct in my web.config, it needs to look like this:

"dbconnectionstr" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\WindowsPowerShell\DscService\Devices.mdb"

…and all I had previously was:

"dbconnectionstr" value="C:\Program Files\WindowsPowerShell\DscService\Devices.mdb"

Pretty sure the tell-tale error is this:

Unable to retrieve Dsc Agent Information with AgentID = d5c98796-3cce-11e7-80d4-005056a77ab8. The underlying error is : Unable to retrieve Agent Id d5c98796-3cce-11e7-80d4-005056a77ab8 from the database. The underlying error is “Format of the initialization string does not conform to specification starting at index 33.”.

Only posting this in the event that someone else lands here for the same reason and I can save them 4 days of head banging :wink: