Welcome to the navigation

Ut nostrud in id quis consequat, dolor consectetur commodo ea magna laboris eiusmod sunt ullamco est fugiat minim ex nulla aute tempor eu ad aliqua. Excepteur in aute exercitation qui minim sint laboris sunt et esse irure veniam, occaecat velit culpa aliqua, consectetur ex do proident, labore commodo id eiusmod

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.

Please note that this portal is a BETA site , I will continuously improve all functionality and performance during the coming weeks / the author