DSC - Use SQL instead of ESENT

Welcome Forums DSC (Desired State Configuration) DSC - Use SQL instead of ESENT

This topic contains 0 replies, has 1 voice, and was last updated by  KAMI04 2 weeks, 5 days ago.

  • Author
  • #173698

    Topics: 2
    Replies: 1
    Points: -9
    Rank: Member


    I'm fighting since 2 days to have DSC working with SQL server instead of this crappy ESENT DB. The reason is mainly the DB size which is not under control...

    Current test setup: Windows 2016 Server for my pull server on a server which is security compliant (old ssl and tls version are disabled).

    I first tried to use the SQL info from MS page but it's not working, I can't find any proper info on errors except this message : "[[xDSCWebService]PSDSCPullServer] Only ESENT is supported on Windows Server 2016" but when I read MS doc only WMF 5.1 and Windows server version greater or equal to 17090... Can't really find which version of Windows it is.

    Because I can't use that build-in stuff I switched to mdb, findings several topics with many different info, I'm almost done except on the ODBC sutff, I can't use SQL server drive because of old version of tls/ssl protocols being disabled. I can only use SQL Server Native client 11.0 but then I have this error :
    w3wp (5872) CreateRepositoryInstance: An attempt to create the folder "c:\windows\system32\inetsrv\Provider=Microsoft.Jet.OLEDB.4.0;Data Source=$env:PROGRAMFILES\" failed with system error 267 (0x0000010b): "The directory name is invalid. ". The create folder operation will fail with error -1023 (0xfffffc01).

    I tried with both :

    'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\WindowsPowerShell\DscService\Devices.mdb;'

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

    with no luck...

    I'm now a bit....lost. I read Windows 2019 should allow using SQL directly but sounds a bit overkill to have a new version of Windows to get this thing working as it should.

    Any idea or suggestion ?

    Thanks 🙂



You must be logged in to reply to this topic.