Welcome to the navigation

Incididunt elit, sint officia cupidatat anim veniam, dolor dolore est et aute in tempor amet, id magna nisi ad reprehenderit proident, nulla culpa voluptate ut. Culpa in do excepteur proident, adipisicing nulla elit, dolore in eiusmod officia aliqua, commodo exercitation consectetur ut pariatur, laborum, sed amet, lorem veniam, tempor dolor

Yeah, this will be replaced... But please enjoy the search!

Get SharePoint ConnectionString using PowerShell

Ever needed the connectionstring to a SharePoint database but really disliked to use regedit.exe? Here is how you'll get it using PowerShell

Note! This is for SharePoint 2015, change the version number for other versions.

Get-Item 'HKLM:\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\Secure\ConfigDB'

This should output something like this

To get the dsn alone you can use the GetItemProperty instead

(Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\Secure\ConfigDB').dsn

Cheers.