Blog Post

Core Infrastructure and Security Blog
7 MIN READ

Configuring a PowerShell DSC Web Pull Server to use SQL Database

BrandonWilson's avatar
BrandonWilson
Icon for Microsoft rankMicrosoft
Sep 20, 2018
  First published on TechNet on Jul 09, 2018   Introduction   Hi! Thank you for visiting this blog to find out more about how you can configure a PowerShell DSC Web Pull Server to use an S...
Updated Jul 07, 2020
Version 5.0
SergeZuidinga
SeZuidin's avatar
SeZuidin
Icon for Microsoft rankMicrosoft
Apr 03, 2019

Hi,

 

As you may have noticed, we're using Provider=SQLOLEDB.1 to connect to our SQL server which may introduce issues when TLS v1.2 is required.

If you want to leverage TLS v1.2 you can follow these steps:

  1.  - download the SQL 2008 and 2008 R2 TLS 1.2 SQL Native Client update or Microsoft® SQL Server® 2012 Native Client
  2. - install the SQL client on your DSC Web Pull Server
  3. - open the web.config with your favorite editor and change <add key="dbconnectionstr" value="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=SQL\DSC" /> to <add key="dbconnectionstr" value="Provider=SQLNCLI11;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=SQL\DSC" />

This enables our DSC Web Pull Server to use the SQL native client.

 

Happy DSC-ing :smileyhappy: